Question

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

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

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Question 01:

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please do it in Excel formula Format Question 01: One hundred years ago, your great grandfather...
Please do it in Excel formula Format Question 01: 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...
Founded nearly 50 years ago by Alfred Lester-Smith, Beautiful Clocks specializes in developing and marketing a...
Founded nearly 50 years ago by Alfred Lester-Smith, Beautiful Clocks specializes in developing and marketing a diverse line of large ornamental clocks for the nest homes. Tastes have changed over the years, but the company has prospered by continually updating its product line to satisfy its auent clientele. The Lester-Smith family continues to own a majority share of the company and the grandchildren of Alfred Lester-Smith now hold several of the top managerial positions. One of these grandchildren is Meredith...
Solve the following: 1. You want to be a millionaire in 25 years. If you can...
Solve the following: 1. You want to be a millionaire in 25 years. If you can earn 10% on your investments, how much do you have to save each year to hit that $1,000,000 mark? Table______________________ 2. Amy is 65 and has $350,000 in her retirement account. An actuary has determined that if her investments earn 7%, she can withdraw $32,300 annually. How many more years does the actuary expect Amy to live? Table______________________ 3. Karla sued her landlord 5...
Question 1: Sea Masters Co. has identified an investment project with the following cash flows for...
Question 1: Sea Masters Co. has identified an investment project with the following cash flows for the next 5 years. If the discount rate is 6.7 percent, the present value of these cash flows is $__________. Round it to two decimal places without the $ sign, e.g., 23456.34                         Year           Cash Flows                           1              $21,000                           2 35,000                           3               44,000 4 53,000                           5               77,000 Question 2: The present value of the following cash flow stream is $6,561 when discounted at...
QUESTION 1 Josh is 7 years old and LOVES to play video games. He spends every...
QUESTION 1 Josh is 7 years old and LOVES to play video games. He spends every spare minute that he has playing Call of Duty and every other combat game around.   One evening when his parents were watching the news, they showed a shooting that happened in a school. Josh seemed to be totally uninterested and not affected by the carnage. Josh could be experiencing the __________________________________. mood congruent binding numbing effect generic cues QUESTION 2 Mary has her multiplication...
1. John invested $20,000 fifteen years ago with an insurance company that has paid him 8...
1. John invested $20,000 fifteen years ago with an insurance company that has paid him 8 percent (APR), compounded quarterly (every 3 months). How much interest did John earn over the 15 years? a. $2,416.08 b. $45,620.62 c. $24,000.00 d. $28,318.95 e. $65,620.62 2. You are running short of cash and really need to pay your tuition. A friend suggests that you check out the local title pawn shop. At the shop they offer to loan you $5,000 if you...
WEEK 4 FIN CORP (ASSNGMNET) SHOW YOUR CALCULATIONS FOR #7-#20. You have the option of performing...
WEEK 4 FIN CORP (ASSNGMNET) SHOW YOUR CALCULATIONS FOR #7-#20. You have the option of performing calculations manually BUT ARE STRONGLY ENCOURAGEDto use a financial calculator or spreadsheet. Either way, you must specify what is being calculated to earn credit: 1,If you are earning a salary of $42,000 in 2018 and expect to receive 4% raises per annum on January 1, what do you anticipate your salary will be in 2027? 2.What is the future value of $5,000 invested for...
Polly Peyrotte started designing and decorating fine china plates more than 100 years ago. As her...
Polly Peyrotte started designing and decorating fine china plates more than 100 years ago. As her artistry caught on, she became famous. She also turned out to have considerable business skills. She grew her design studio into what today is Polly Plates, Inc. (PPI), with $36 million in annual revenue. Polly’s daughters and granddaughters became involved in the business after Polly’s retirement and hired talented designers who could carry on Polly’s tradition of beautiful plates. In recent years, however, fewer...
You are one of five partners and a vice-president in Performance Evaluation, Ltd. (PEL), a mid-size...
You are one of five partners and a vice-president in Performance Evaluation, Ltd. (PEL), a mid-size consulting firm that specializes in evaluation, assessment and engineering analysis. Your firm’s chief clients are the U.S. Department of Energy, the U.S. EPA, and various state government energy and environmental agencies. Most of your work involves technical and policy analysis, prospective and retrospective. Illustrative recent projects include: (1) a major three-year study estimating the cost and available technologies for cleaning up hazardous waste at...
Lance H. and Wanda B. Dean are married and live at 431 Yucca Drive, Santa Fe,...
Lance H. and Wanda B. Dean are married and live at 431 Yucca Drive, Santa Fe, NM 87501. Lance works for the convention bureau of the local Chamber of Commerce, while Wanda is employed part-time as a paralegal for a law firm. During 2018, the Deans had the following receipts: Salaries ($60,000 for Lance, $41,000 for Wanda) $101,000 Interest income—  City of Albuquerque general purpose bonds $1,000  Ford Motor Company bonds 1,100  Ally Bank certificate of deposit   400 2,500 Child...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT