Question

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
Please provide the formulas for excel as well

Answer 1

1)
Rate = 8.78%/12	0.7317%
Nper = 10 x 12	120
Pmt	$         100.00
PV	$      1,000.00
FV	$    21,510.99
Type	0
2)
	Option 1	Option 2	Option 3
Rate =	0.433%	1.300%	5.200%
Nper =	240	60	10
Pmt	$         800.00	$         3,200.00	$           19,200.00
PV	$ 1,19,732.03	$    1,32,746.84	$        1,46,827.85
FV	$                -	$                   -	$                        -
Type	1	0	0