A complex property investment forecasting spreadsheet requires modification to cater for the following additional parameters per property:
- Principal and Interest loan type
- Principal amount
- Loan term
- Payment frequency
- Extra loan repayments
- New loan term (if payment frequency changed or extra loan repayments made)
- Offset balance
- Repayment amount
P&I interest is to be calculated daily.
The principal payments then need to be taken into account on the cashflow summary tab.
Expert level Excel skills are required.
Native Excel formulas only to be used in Excel 97 format - no VB scripting or macros.
Additional work will be available if this task is completed successfully.
32 freelancers estão ofertando em média $162 para esse trabalho
I am an Excel expert - cleverly use Excel formulas and functions. I have created many complex templates in Excel. Please take a look at my reviews for Excel projects and consider me positively.
Hello! I can do what you need. I have 12 years of experience in investment banking, financial analysis and accounting, including 4 years at a Big-4 audit firm.
Hi, PhD qualified with more than 7 years Financial Projections experience available here to work for you in excellent way. True Excel Expert here..............