Question

In: Accounting

Required: Solve these question in Microsoft Excel Five Years Ago Leslie Had $23460 In Her Saving...

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

Solutions

Expert Solution

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)

Related Solutions

Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You want to retire on the day you have $1,000,000 is your savings account. You expect to earn 4 percent compounded monthly, on your money during your retirement. Your plan is to withdraw $4500 a month as retirement income from this account. How many years can you be retired until you run out of money? . Question 02: you are able to pay mortgage payments...
1. Use Microsoft Excel to solve the question . The initial cost of an asset is...
1. Use Microsoft Excel to solve the question . The initial cost of an asset is BD100000. It has useful life of 9 years. The estimated salvage value of the asset at the end of useful life is zero. Calculate the annual depreciation and book value using double-declining balance method and find out the year in which the switching is done from double-declining balance method to straight-line method. Theory related to switching : Switching between different depreciation methods:- Switching from...
How to solve this question on Microsoft Excel The annual commissions earned by sales representatives of...
How to solve this question on Microsoft Excel The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery, follow the normal distribution. The mean yearly amount earned is $40,000 and the standard deviation is $5000. a. What percentage of sales representatives earn between $32,000 and $42,000 per year? b. What percentage of sales representatives earn more than $42,000 per year? c. The sales manager wants to award the sales representatives who earn the largest...
Without excel or excel steps Review Question 2 Suppose you bought a house 12 years ago...
Without excel or excel steps Review Question 2 Suppose you bought a house 12 years ago with a 30-year mortgage for $200,000. The mortgage has a fixed interest rate of 7 percent compounded monthly. (a) What are the monthly mortgage payments? (b) What is the amount if you pay off your mortgage today? You just made the recent mortgage payment earlier today. A. monthly mortgage payments ? B. of 360 payments 144 done, 216 left but I made one today...
Five years ago, Debora gave a life insurance with a $750,000 death benefit to her daughter,...
Five years ago, Debora gave a life insurance with a $750,000 death benefit to her daughter, Linda. At the time of gift, the value of the life insurance was $65,000, and Debora paid $10,000 in federal gift tax. Debora passed away this year. What amount will be included in her federal gross estate related to this life insurance policy.
10-4 Suppose that five years ago Cisco Systems sold a 15 years bond issue that had...
10-4 Suppose that five years ago Cisco Systems sold a 15 years bond issue that had a $1000 par value and a 7 percent coupon rate. Interest is paid semiannually. a- If the going interest rate has risen to 10 percent, at what price would the bonds be selling today? b- Suppose that the interest rate remained at 10 percent for the next 10 years. What would happen to the price of Cisco's bonds over time?
2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...
2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line. X-Bar 2 4 5 6 Y-Bar 7 11 13 20
Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter...
Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter grade Nested loop Student ID Grade Letter Grade 1 5 If score is Then return 2 55 Greater than 89 A 3 86 From 80 to 89 B 5 64 From 70 to 79 C 6 25 from 60 to 69 D 7 56 less than 60 F 8 58 9 99 10 90 11 28
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
Five years ago, you had arranged for an eight-year bank loan for $300,000 at an interest...
Five years ago, you had arranged for an eight-year bank loan for $300,000 at an interest rate of 10% p.a. with interest compounded semi-annually. The loan was being repaid in equal semi-annual instalments and the payments were being made at the end of each period. The total amount still owed the bank today is closest to? Could you please show the solution step by step instead of using Excel functions…Thanks a lot!
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT