Question: ANNUITIES Please use Excel function to answer the following: 1. Suppose you are buying a car with the following information car price: $32,000 Number of

ANNUITIES

Please use Excel function to answer the following:

1. Suppose you are buying a car with the following information

car price: $32,000

Number of monthly payments 48

APR: 6.00%

What is the monthly payment?

2. Suppose you are saving for your retirement. You are 23 Years old and you want to retire in 42 years.

Retirement goal: $1,200,000

APR: 6.5%

a. How much will you need to save each month in order to meet your retirement goal?

b. If your retirement goal is 1,500,000 instead and you will save the same amount each month found in part (a), what is the APR you need to earn in order to meet the retirement goal of $1,500,000?

3. If your retirement goal is $1,500,000 and you are able to save $1,200 each month, how many years do you need o have $1,500,000 in your retirement account, assuming APR is 8%?

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!

Please use excel spreadsheets to answer the following questions. Provide the excel formulas used. You are thinking about buying a new car with a sticker price of $25,000. Since you do not have that...

Please Use Excel function and same layout shown in pic.; the gray number/box is the correct answer (b/c it auto correct my answer after so many time). Bond Pricing using Excel's VLOOKUP, IF and Basic...

1) The price of a computer component is decreasing at a rate of 8% per year. State whether this decrease is linear or exponential. If the component costs $ 90 today, what will it cost in three years?...

Chapter 5 - Section 1 Future Value and Compo Now that we have calculated the future value of a lump sum with the Interest rate per 12% Number of years 3 Initial investmen $ 400 How much will you have...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

answer the questions in the files. mc and some questions 1. Present Value of Multiple Annuities (LG4) A small business owner visits his bank to ask for a loan. The owner states that he can repay a...

I would like to know if someone can assist with inputting the formulas into the Excel spreadsheets..... Answers are provided, however, the formulas were omitted. Week 9 Chapter 21: Problems 3(a-e),...

Demand Estimation Assignment - iScream Ice Cream Co. iScream is a Chicago start-up that sells ice cream in several mobile ice cream trucks. The main innovative feature of their business is the...

Looking for assistance in Finance HW..... I ONLY Need the FORMULASin the function ribbon (for the answers that I already have, which are attached below) Please advise if you can assist and provide...

The probability that Jack passes calculus II given that he passes Calculus I is 0.8. The probability that Jack passes Calculus Ii given that he fails Calculus I is 0.3. Likewise, the probability that...

Match each entry in Column a with one in Column b; Column a shows the names of some important functional groups, and Column b shows their structures. Columna Amino group Carbonyl group (ketone)...

Q 1 . [ 4 points ] What is the Net Income of XYZ Inc. in 2 0 2 2 ? Q 2 . [ 4 points ] Based on balance sheet identity, total assets equal to total liabilities, what are the accumulated retained...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

8-10 This project uses spreadsheet software to calculate anticipated annual losses from various security threats identified for a small company. Mercer Paints is a paint manufacturing company located...

8-8 Gifty is an online e-tailer for handmade gifts. Customers can purchase either via its Web site or via a mobile app. Prepare a security analysis for this Internet-based business. What kinds of...

8-16 Describe some of the weaknesses exploited by malware The IT sector is one of the key drivers of the European economy. It has been estimated that 60 percent of Europeans use the Internet...