We require the attached MS Excel Calculator to demonstrate the longevity of a home loan based on a number of pre-defined inputs. These inputs may see the loan repaid prior to the length of the default projection term (10 years). We need the calculator to create a projection that ceases at the date at which the home loan is paid off (ie. goes to $0) and the associated report (seperate worksheet) plus other worksheets to reflect the results based on the length of this new projection term.
ie. We do not want to see the spreadsheet go past when the loan balances reaches $0 and we want the output to reflect this shortened projection term.
Note that the attached spreadsheet has simple built-in navigational macros as part of it already.
It is a standalone MS Excel Spreadsheet that has no links or connection to external data sources.
The "Cash Flow" Worksheet of the attached Spreadsheet (titled - "Debt Management Calculator) calculates the pay-down of a home loan based on certain inputs (taken from "main menu", "income and expenses", "assumptions", "data" and "tax" worksheets). This often means based on these assumptions that the home loan value in the "Loan Values" with and without the program (cells A16 and A16 respectively) can go negative.
I need to have this corrected so that:
1) The term of the projection under this worksheet ceases at the date at which either loan value reaches or goes below $0
2) The "Cash Flow - Yearly Summary" worksheet only shows the full years prior to the year in which the term of the projection ceases and the part of the year up to the point at which either loan value reaches or goes below $0
3) The "Tax" worksheet only shows the full years prior to the year in which the term of the projection ceases and the part of the year up to the point at which either loan value reaches or goes below $0
4) The "Report" worksheet shows output reflecting the term of the projection, and changes i) the loan balances, ii) the asset balances, iii) equity calculatiions, iv) asset allocation, v) home loan balance chart and vi) the other benefits based on the calculations flowing out of the "Cash Flow" worksheet. ie. they will show a report demonstrated against the term of the projection (which is up to the point at which either loan balances reaches or goes below $0).
This spreadsheet has been written under Microsoft Excel 2003 but needs to also run on Microsoft Excel 2002. This is run under Microsoft XP and networked across our business.