Question: I would like to know how to do it on EXCEL. You want to buy a $200,000 house and plan to pay 20% of the

I would like to know how to do it on EXCEL.

I would like to know how to do it on EXCEL. You

You want to buy a $200,000 house and plan to pay 20% of the purchase price as a down payment and finance the rest. You currently have $2,000 to invest. If you invest your $2,000 in a mutual fund with an average annual return of 6%, then how many years must you wait to achieve your goal? Use the appropriate formulas and Excel function to solve the problem (typed-in solutions receive 0 credit). Use Answer PV PMT Answer 51.41

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!

Customer Profile: Mr. & Mrs. Austin Mary and Steve Austin have been married for 5 years and have a 4-year-old daughter named Lindsay. The Austin's are starting to think more about their future with...

For this assignment, you will financially plan the rest of your life. You will be able to make choices about certain aspects, but there are two unbreakable rules: Rule #1: You must always spend...

Hi!!! Please see attached and answer using formulas on excel. Thank you. Problem 27-4 Quarterly working capital levels for your firm for the next year are included in the following table. What are...

Your assignment must be handed in as an Excel spreadsheet, with a monthly budget for the rest of your life (25 marks). In a separate file (Word or PDF), write a summary of your life (5 marks),...

Finder Fiv Edit View Go Windo x | + O File /Users/owner/Downloads/assignment.html LILUKULL. LIETILI WA KUWA WILyuda RIWILI ILULIITMIL THAIL 16 2.5 Calculate the social security tax. The social...

Customer Profile: Mr. & Mrs. Austin Mary and Steve Austin have been married for 5 years and have a 4-year-old daughter named Lindsay. The Austins are starting to think more about their future...

Pro Customer Profile: Mr. & Mrs. Austin Mary and Steve Austin have been married for 5 years and have a 4-year-old daughter named Lindsay. The Austins are starting to think more about their future...

Submit in Excel spreadsheet, with a monthly budget for the rest of your life (25 marks). In a separate file (Word or PDF), write a summary of your life (5 marks), explaining the choices you made and...

Customer Profile: Mr. & Mrs. Austin Mary and Steve Austin have been married for 5 years and have a 4-year-old daughter named Lindsay. The Austins are starting to think more about their future with...

Susana biked 7 miles to the store and 7 miles back in a total of 3 hours. If she travelled 2 mph slower on the way bad approximately Required: how fast was she travelling on the way there? Input the...

Using the following trial balance and adjustment data for Vivians Repair Co. of Windsor, prepare: 1. A worksheet for October 2. An income statement for October, a statement of owners equity for...

What is the payback period of Project X ? 2 . 2 5 years 2 . 3 8 years 2 . 4 9 years 2 . 5 4 years 2 . 8 9 years

Please do not copy another person's answer which published on Chegg, bcz itz wrong. Please answer these questions (10 p) Consider the following sentences: Animals can outrun any animals that they...