Excel problems for economics

On Excel, demonstrate that you can solve for PV, FV, PMT,  and IRR.

1. What is the FV of an investment of $10,000 which pays 7% interest, compounded monthly, for five years?  What is the FV is it’s compounded semi-annually for 5 years? 

2.  What is the monthly payment for a $800,000 mortgage for the first 119 payments that is due in 10 years, has a 25 year amortization, at 5% interest? What is the amount of the 120th payment?

3.  What is the IRR of a $10,000 investment which pays $500 end of year 1, $0 end of year 2, $800 end of year 3, $900 end of year 4 and $10,600 at the end of year 5?

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.