Question
Required: Solve these question in Microsoft Excel Question 01: Five Years Ago Leslie Had $23460 In Her Saving Account Today She Deposited An Additional $6,000
Required: Solve these question in Microsoft Excel
Question 01: 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.
Question 02: 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?
Question 03: 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started