Question: Interest 0 . 1 Time 0 1 2 3 CF ( cash flow ) 1 0 0 FV ( fair value ) 1 3 3

Interest 0.1
Time 0123
CF(cash flow)100
FV(fair value)133.1
What's the FV of a 3-year ordinary annuity of $100 at 10%? What's the PV?
(make into a separate sheet with same chart setup in excel)
How do we find EAR% for a nominal rate of 10%, compounded semiannually?
(make into a separate sheet with same chart setup in excel)
Exercise: Construct an amortization schedule for $1,000,10%, annual rate loan with 3 equal payments and complete it.
(make into a separate sheet with same chart setup in excel)
PLEASE SHOW IN EXCEL NO HARD CODING HAS TO BE DONE EXCEL TO SHOW FORMULAS AND USE CELLS DO NOT INPUT NUMBERS YOU MUST CLICK ON THE CELLS

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!