Completed

Excel Calculator

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.

## Deliverables

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).

## Platform

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.

Evner: Ingeniørarbejde, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Software Arkitektur, Software Testning, Word

Se mere: want to create a chart, pre flow, microsoft excel spreadsheet, microsoft excel management, excel spreadsheet business, cash engineering, calculator program in php, spreadsheet microsoft excel, reflecting, loan calculator, home loan, excel calculator, debt equity, create excel worksheet, excel data projection, excelchart, engineering management report, expenses report, projection projection, excel projection

Om arbejdsgiveren:
( 2 bedømmelser ) Australia

Projekt ID: #3319368

Tildelt til:

quandan

See private message.

$42.5 USD in 14 dage
(3 bedømmelser)
1.9

5 freelancere byder i gennemsnit $36 på dette job

Premshanks

See private message.

$25.5 USD in 14 dage
(355 bedømmelser)
6.5
thespreadsh

See private message.

$42.5 USD in 14 dage
(131 bedømmelser)
5.4
raojune

See private message.

$33.15 USD in 14 dage
(7 bedømmelser)
2.4
dribblevw

See private message.

$25.49 USD in 14 dage
(6 bedømmelser)
1.5
salamsoft

See private message.

$38.25 USD in 14 dage
(1 bedømmelse)
0.0