Lenny D. answered 07/09/19
Financial Professional with many years of Wall Street Experience
all of the dollar signs and backslashes confuse the heck out of me.
Your cash Flows look something like this.
Year Cash Flow
0 -1000
1 900
2 800
3 -1200
4 700
At the end of year one you will have a loan balance of 1080 (the loan accrues at 8%). in year 1 you have a cash flow of 900. if you put the money on deposit you would only earn 5%. If you paid down 900 of your loan balnce you would be reducing your 8% interest charges. You will be effectively earning 8% by doing so.. That will leave you with a loan balance of 180 which will accrue at 8% for another year.
In year 2 you receive 800 dollars if you pay off your existing debt you can put the balance of $605.6 on deposit which will grow at 5%.
In year 3 you have an outflow of 1,200. Part of this can be funded by your deposit (effectively borrowing at 5%) and the balance funded at 8%.
In year 4 you pay off the second loan with the 700 cash flow and are left with $90.75. If you discount this back to present value at 5% it is how much you would have to put on deposit to have 90.75 in 4 year. If you discount it at 8% it is how much additional money you could borrow using the Future value of the cash flows as collateral..
Year Cash flow Balance
0 -1000 -1000
1 900 -180
2 800 605.6
3 -1200 -564.12
4 700 90.75
I hope this helps. Please feel free to reach out if you need help with this material.