Please see the instructions attached and apply them to the excel worksheet. please make sure to follow exact instructions.
Week 12 Module 9 Project 1A Hints
Loan Payments Worksheet
=SUM(C17:G17)
=SUM(C18:G18)
=C19/$D$5
=CUMIPMT($D$7,$D$9,$D$5,C15,C16,0)
Depreciation Worksheet
=C12+D11
=SLN($D$5,$D$6,$D$7)
=DB($D$5,$D$6,$D$7,C17)
=SYD(D5,D6,D7,C17)
=SYD(D5,D6,D7,I17)
Investment Worksheet
=NPV(C14,C7:C12) ignore error
=IRR(C6:C12)
