Question: please help. i don't understand at all with the five questions that are on the spread sheet. Problem 1 - Future Value of Investment If

please help. i don't understand at all with the five questions that are on the spread sheet.

please help. i don't understand at all with the five questions that

Problem 1 - Future Value of Investment If a firm has $250,000 to invest and can earn 8.5%, compounded annually, how much will the firm have after two years? Rate Nper PMT PV Type FV Problem 2 - Future Value of Retirement Account A self-employed person deposits $1,250 annually in a retirement account that earns 5.5%. What will be the account balance at age 62 if the savings program starts when the individual is age 50? Rate Nper PMT PV Type FV How much additional money will be in the account if the saver defers retirement until age 66 and continues the annual contributions until th Hint: First calculate the FV of the account at age 66 and then subtract the FV determined above (at age 62) to arrive at the additional mon Rate Nper PMT PV Type FV Additional money saved if the contributions continue until age 66 The first part is a repeat of 1a. How much additional money will be in the account if the saver discontinues the contributions at age 62, but lets it build up until retirement a Hint: First calculate the FV of the account at age 62, then utilize the FV of the account at age 62 as the PV in the FV calculation for the nex Finally, subtract the FV of the account at age 62 from the FV of the account with no additional contributions to arrive at the additional mon Rate Nper PMT PV Type FV Rate Nper PMT PV Type FV Additional money saved if contributions stop at age 62, but the money keeps growing until age 66. then? oney saved. t at age 66? ext 4 years. oney saved. Problem 3 - Present Value of Savings Account A father has decided to set aside a one time lump sum for college that will amount to $60,000 by the time his 5 year old is 18 years old (13 years). Using 8% as the rate and assuming no further investments will be made, how much must the father invest today in order to have $60,000 in 13 years? Rate Nper PMT FV Type PV Problem 4 - Home Loan A couple borrows $935,000 for 7 years for the purchase of a vacation home at an interest rate of 7%. The loan requires that the interest and principal be paid in equal, annual payments. The interest is determined on the declining balance that is owed. What are the required annual payments on the loan? Rate Nper PV FV Type PMT Yearly payment owed How much is the principal loan balance reduced by during the first year? Hint: To determine the principal paid in year 1, subtract the interest paid in year 1 from the total yearly payment. Rate Principal loan value Interest paid in year 1 Total payment made in year 1 Principal paid the first year Problem 5 - Lease Payments A company leases equipment for 7 years. The equipment costs $28,000 and the owner wants to earn 9.5% on the lease. What should be the required lease payments? Rate Nper PV FV Type PMT

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!