advanced spreadsheet assisgnment

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)