Advanced Financial Spreadsheet Creation
Budget: £10 – £20 GBP
I need a spreadsheet that calculates cost by adding 3 inputs, and multiplying them by 2 further inputs. This is the base cost in yr one. Another input ( the interest cost ) needs to be calculated annually producing the total debt (Simple so far)
It also needs to calculate returns receiveable from just two other cell values to produce annual return. Annual return needs to be deducted from the debt to produce net debt which is then carried forward to the next year, where interest is applied to the debt and return is deducted from the debt and so on. (Still simple.)
What I need help on is the formula that will do the following:
Debt shoudk always be shown as a negative value, and credit as a positive. When debt reaches 0, the only calculations made, and data to be shown, are the annual return and the cumulative value of last year's return plus this year's return. This function needs to run from year one as the year in which all debt is repaid (value =/> ) is unknown and will change depending on the value of all the source data used to create the start values.. Please tell me if anything needs explaining.
It also needs to calculate returns receiveable from just two other cell values to produce annual return. Annual return needs to be deducted from the debt to produce net debt which is then carried forward to the next year, where interest is applied to the debt and return is deducted from the debt and so on. (Still simple.)
What I need help on is the formula that will do the following:
Debt shoudk always be shown as a negative value, and credit as a positive. When debt reaches 0, the only calculations made, and data to be shown, are the annual return and the cumulative value of last year's return plus this year's return. This function needs to run from year one as the year in which all debt is repaid (value =/> ) is unknown and will change depending on the value of all the source data used to create the start values.. Please tell me if anything needs explaining.