1. Business
  2. Finance
  3. unfortunately this is my second time uploading this because instructions...

Question: unfortunately this is my second time uploading this because instructions...

Question details

Unfortunately this is my second time uploading this because instructions were not read properly. I need full excel formulas for each answer. for example: PV(.085,5000,8,1000.0) this is required for each answer. There are 6 in this one multi part question. Thank you...

Excel File Edit View Insert Format Tools Data Window Hel 0书20% Tue 11:31 PM a 385excel project.xlsx fou A 100% QSearch in Sheet A Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Cells Themes ス, LI Fill ▼ :| Verdana A- Aabrapxt General 0 Conditional Bd insert Delete Format Themes Aa M | ; | * O (-fx | How much money will you have in 10 years if you deposit $1,000 today followed by $100 per month in a mutual fund that provides a return of 8.78% APR? 22 FV 23 Type 24 25 Your Preferred Choice 26 You want to buy a house in five years. You prefer to live in an area in which houses are currently selling at an average price of $325,000. You know that the average price of the houses in the area will likely increase by 1.25% per year over the next five years. 28 29 30 What will be the averoge price af a house in the area in five years? 31 32 Rate 33 Nper 34 PMT 35 PV 36 FV 37 38 1 point per box Type You know that you will need to save enough money over five years to be able to have a down payment of 20% of the price of the house. You plan to deposit $1,000 immediately in an account that pays 4.5% APR compounded monthly, what will be the amount of the payment that you will need to make at the end of each montn to have your down payment at the end of five pays 45%aveyour own 39 years 40 41 Rate 42 Nper 43 PMT 44 PV 4S FV 46 1 point per box Type u + CoverPro-Forma StatementS TVM Computations Car Loan Bond Valuation Normal View Ready Sum 0 15

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution