1. Business
  2. Accounting
  3. please provide the formulas for excel as well...

Question: please provide the formulas for excel as well...

Question details

Excel File Edit View Insert Format Tools Data Window Hel ACFI 385 Excel Project Winter 2019(1) (2).xlsx 1 00% ▼ |Search in Sheet Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Aignme Fill ▼ Verdana Wrap TextCeneral Good Conditional Check Cell Insert Delete Format Themes Aa 41 ; * O ( Analyze the following scenarios that will require you to compute either the present value, future value, and/or the a payment amount. Indicate the inputs that you will use to perform your analyses in x Analyze the following scenarios that will require you to compute ether the present value, future value, andfor the a payment amount. Ind lcate the inputs that you will use to perform your analyses in the spaces provided. Perform your calculation in the space provided for that amount. For example, if you need to compute that present value, present that calculation in the PV space. How much money wi you nave in 10 years if you deposit S1,000 today followed by S100 per month in a mutual fund that | provides a return of 8.78% APR? Points Earned 4 1 point per box 6 Rate 7 Nper 8 PMT 9 PV 10 FV 11 Type 12 13 You received a surprise not fication fram an attorney that you are the benefidary af a payout fram the estate of a long lost relative. You must chose one of the following three options of how you will receive the payout. Determine the value of each option. Then indicate your preferred choice. Assume that you can invest your money at 5.2% APR> 14 15 16 Option #1 Option #2 $3,200 per quarter for 15 years Option #3 $19,200 per year for 10 years beginning in one year 20 years beginning immediately beginning in three 1 point per box 17 18 Rate 19 Nper 20 PMT 21 PV 22 FV 23 Type CoverPro-Forma Statements TVM Computations Car Loan Bond Valuation Normal View 15| Excel File Edit View Insert Format Tools Data Window Hel ACFI 385 Excel Project Winter 2019(1) (2).xlsx 1 00% Home Layout Tables Charts SmartArt Formulas Data Review ▼ |Search in Sheet Edit Font Aignme abc ▼ FillVerdana Wrap TextCeneral Good Clear BI Conditional Check Cell * O ( Insert Delete Format Themes Aa 41 ; Analyze the following scenarios that will require you to compute either the present value, future value, and/or the a payment amount. Indicate the inputs that you will use to perform your analyses in x 23 Type 24 25 Your Preferred Choice 26 27 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 wil likely increase by 1.25% per year over the next five 28 29 average price of a house in the area in five years? 31 32 Rate 33 Nper 34 PMT 35 PV 36 FV 37 Type 38 1 point per box 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 S1,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 or eon montn to have your down payment the end of fve 39 years. 40 41 Rate 42 Nper 43 PMT 44 PV 45 FV 46 Type 47 48 1 point per box Pro-Forma State ments TVM Computations LoanBond Valuation Normal View Sum-0 15Please provide the formulas for excel as well

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