Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator.

Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help meet this goal, and will also deposit $8 million at the end of the next 15 years, to meet this liability. What annual rate of interest must the account earn to meet the liability? What is the present value of an ordinary annuity that promises $20,000 per year for 20 years if the appropriate discount rate is 5%? What is the present value of an annuity due that promises $20,000 per year for 20 years if the appropriate discount rate is 5%? What is the future value of an ordinary annuity that promises $60,000 per year for 10 years if the appropriate interest rate is 4%? What is the future value of an annuity due that promises $60,000 per year for 10 years if the appropriate interest rate is 4%? You recently received a credit card that quotes an annual percentage rate (APR) of 24%. The card requires monthly payments. What is the effective annual rate (EAR)?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Supernatural Provision Living In Financial Freedom

Authors: Joan Hunter, Sid Roth

1st Edition

1641238232, 978-1641238236

More Books

Students also viewed these Finance questions

Question

Design a health and safety policy.

Answered: 1 week ago