Hi, need someone to build this for me please
House $200,000 $150,000
Car $20,000 $30,000
Investments $45,000 $56,000
Mortgage -$150,000 -$130,000
(b) Using Excel Help; find the formula for calculating the effective annual interest rate of return.
Syntax: =EFFECT(nominal_rate, npery)
(c) Create a second table and populate the first row with Sandra’s current mortgage balance.
(d) Populate a cell with the mortgage interest rate (7%) and a second cell with the monthly repayment amount ($900).
(e) Design a formula that will populate the rest of Sandra’s repayment schedule, assuming the interest is calculated annually. Make sure the formula uses absolute cell references to refer to the values that you have already created