Question: Seek command in Excel to nd the net borrowing cost for this package by including the annual fee (expressed as a rate p.a. compounded monthly).

 Seek command in Excel to nd the net borrowing cost for

this package by including the annual fee (expressed as a rate p.a.

Seek command in Excel to nd the net borrowing cost for this package by including the annual fee (expressed as a rate p.a. compounded monthly). Please refer to table 3 for his calculations. Table 3: Jimmy's Excel spreadsheet. _'- Borrowed amount Net borrowing 1. 3388% cost per month Interest rate 3'12 Net borrowing 16.066% cost 3'12 Interest rate per Present value of $346.6621 month the management fee by using net borrowing rate Number of Present value of 8000.00 Number of Loan repayment $80 interestonly for the rst three payments months Management fee Loan repayment $424.2460 for the following 21 months a. [ 3 marks] Give the Excel cell formulae you would use to calculate the value of cells D5 and D6. b. [ 2 mark] Give the Excel cell formulae you would use to calculate the value of cell D3. c. [ 3 mark] Give the Excel cell formula you would use to calculate the value of cell D4. (:1. [ 3 marks] Describe the steps Jimmy used to generate his result in cell D1 using Goal Seek

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!