In: Accounting
Required: Solve these question in Microsoft Excel
Five Years Ago Leslie Had $23460 In Her Saving Account Today She Deposited An Additional $6,000 She Plans To Deposit Another $6,000 Into This Account Next Year How Much Money Will She Have In Her Account Ten Years From Today If She Earns 7.5 Percent On Her Savings.
One hundred years ago, your great grandfather purchased a 300-acre farm for the princely sum of $2500. Today,, that farm is still owned by your family and is currently valued at $1.8 million. What rate of return has your family on this investment by your great grandfather?
you are the pension fund consultant to the Home Depot and are trying to estimate the present value of its pension obligations which are expected to be the following.
Years |
Annual cash flow |
|
1 to 5 |
$ 200 million |
|
6 to 10 |
$ 300 million |
|
11 to 20 |
$ 400 million |
Find the present value of these pension obligations.
Note: Solve the Problem in Excel
Answer 1
FV = $23,460(1.075)15 + $6,000(1.075)10 + $6,000(1.075)9 = $69,415.26 + $12,366.19 + $11,503.43 = $93,284.88 | ||||||||
Enter | 15 | 7.50% | ±23,460 | |||||
N | I/Y | PV | PMT | FV | ||||
Solve for | 69,415.26 | |||||||
Enter | 10 | 7.50% | ±6,000 | |||||
N | I/Y | PV | PMT | FV | ||||
Solve for | 12,366.19 | |||||||
Enter | 9 | 7.50% | ±6,000 | |||||
N | I/Y | PV | PMT | FV | ||||
Solve for | 11,503.43 | |||||||
Total FV = $69,415.26 + $12,366.19 + $11,503.43 = $93,284.88 | ||||||||
Answer 2
Enter | 100 | ±2,500 | 1,800,000 | ||
N | I/Y | PV | PMT | FV | |
Solve for 6.8005096 | |||||
Manual check: $2,500(1.068005096)100 = $1,800,000 | |||||
Answer is 6.80% (rounded) |