Question

Please show me the work and formulas in the assigned cells. Thank you.

C D E On the cell B5 enter your PV, on cell B6 the annual retum rate on cell B7 the months of the year, and on the cell B9 calculate the monthly rate. On column C have the years, on column D the months of the year and on column E the periods. Calculate on column F the amount that you will have in your account at the end of each month using your mathematics. Calculate the same amount using an excel function on column G. Bring the FV after 48 months on the cell B4, while in the cell B3 calculate how much is your increase over the given period. In Cell B2 calculate using the EXCEL FV function in such a way 1 that vou will have the same amnunt as in cell R4 2 EXCEL FV 4 FV 5 PV 7 Months 8 Years 9 Monthly rate 12 13 10 10 12 12 1 13 2 14 3 15 4 16 5 17 6 18 7 19 8 20 9 21 10 22 11 23 12 24 1 25 2 26 3 27 4 28 5 29 16 17 8 19 21 2 24 25 27 28 31 3 6 30 7 31 8 32 9 33 10 34 11 35 12 36 1 37 2 38 3 39 4 40 5 41 37 2 4 45 4 6 4:2 7 43 8 44 9 45 10 46 11 47 12 48 49 52

Answer 1

Sol: The work is as under and the formulas assigned are: a) from cell G5 to G52 =FV($B$9,E5,0,-$B$5,0) just drag the formula from cell G5 to G52 and FV table will be ready in column G. FV/PV is simple = B4/B5; in cell B2 use this formula: =FV(B9,48,,-1000,0)

Excel FV	₹ 1,489.35
FV/ PV	1.489
FV	1489.35
PV	1000	1	Jan	1	₹ 1,008.33	₹ 1,008.33
r	10%		Feb	2	₹ 1,016.74	₹ 1,016.74
Months	12		March	3	₹ 1,025.21	₹ 1,025.21
Years	4		April	4	₹ 1,033.75	₹ 1,033.75
Monthly rate	0.83%		May	5	₹ 1,042.37	₹ 1,042.37
			June	6	₹ 1,051.05	₹ 1,051.05
			July	7	₹ 1,059.81	₹ 1,059.81
			August	8	₹ 1,068.64	₹ 1,068.64
			September	9	₹ 1,077.55	₹ 1,077.55
			October	10	₹ 1,086.53	₹ 1,086.53
			November	11	₹ 1,095.58	₹ 1,095.58
			December	12	₹ 1,104.71	₹ 1,104.71
		2	Jan	13	₹ 1,113.92	₹ 1,113.92
			Feb	14	₹ 1,123.20	₹ 1,123.20
			March	15	₹ 1,132.56	₹ 1,132.56
			April	16	₹ 1,142.00	₹ 1,142.00
			May	17	₹ 1,151.52	₹ 1,151.52
			June	18	₹ 1,161.11	₹ 1,161.11
			July	19	₹ 1,170.79	₹ 1,170.79
			August	20	₹ 1,180.54	₹ 1,180.54
			September	21	₹ 1,190.38	₹ 1,190.38
			October	22	₹ 1,200.30	₹ 1,200.30
			November	23	₹ 1,210.31	₹ 1,210.31
			December	24	₹ 1,220.39	₹ 1,220.39
		3	Jan	25	₹ 1,230.56	₹ 1,230.56
			Feb	26	₹ 1,240.82	₹ 1,240.82
			March	27	₹ 1,251.16	₹ 1,251.16
			April	28	₹ 1,261.58	₹ 1,261.58
			May	29	₹ 1,272.10	₹ 1,272.10
			June	30	₹ 1,282.70	₹ 1,282.70
			July	31	₹ 1,293.39	₹ 1,293.39
			August	32	₹ 1,304.16	₹ 1,304.16
			September	33	₹ 1,315.03	₹ 1,315.03
			October	34	₹ 1,325.99	₹ 1,325.99
			November	35	₹ 1,337.04	₹ 1,337.04
			December	36	₹ 1,348.18	₹ 1,348.18
		4	Jan	37	₹ 1,359.42	₹ 1,359.42
			Feb	38	₹ 1,370.75	₹ 1,370.75
			March	39	₹ 1,382.17	₹ 1,382.17
			April	40	₹ 1,393.69	₹ 1,393.69
			May	41	₹ 1,405.30	₹ 1,405.30
			June	42	₹ 1,417.01	₹ 1,417.01
			July	43	₹ 1,428.82	₹ 1,428.82
			August	44	₹ 1,440.73	₹ 1,440.73
			September	45	₹ 1,452.73	₹ 1,452.73
			October	46	₹ 1,464.84	₹ 1,464.84
			November	47	₹ 1,477.05	₹ 1,477.05
			December	48	₹ 1,489.35	₹ 1,489.35