Paul Atreides wants to save money to meet three objectives. First, he would like to be able to retire 20 years from now with retirement income of $15,000 per month for 20 years, with the first payment received 20 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $100,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $100,000 to Chani, his girlfriend. He can afford to save $3,000 per month for the next 10 years. If he can earn an 10 percent EAR before he retires and an 9 percent EAR after he retires, how much will he have to save each month in years 11 through 20? Note: To provide coherence and organization to your work, arrange your work for this question as follows: Step 1: Convert both EARs to annual nominal rates Step 2: Compute the amount needed at the 20-year mark from now Step 3: Compute the amount in hand at the 10-year mark from now Step 4: Compute the amount still required at the 10-year mark Step 5: Compute the shortage/surplus, if any, and compute the required monthly savings between years 11 through 20.

Paul Atreides wants to save money to meet three objectives. First, he would like to be able to retire 20 years from now with retirement income of $15,000 per month for 20 years, with the first payment received 20 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $100,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $100,000 to Chani, his girlfriend. He can afford to save $3,000 per month for the next 10 years. If he can earn an 10 percent EAR before he retires and an 9 percent EAR after he retires, how much will he have to save each month in years 11 through 20? Note: To provide coherence and organization to your work, arrange your work for this question as follows: Step 1: Convert both EARs to annual nominal rates Step 2: Compute the amount needed at the 20-year mark from now Step 3: Compute the amount in hand at the 10-year mark from now Step 4: Compute the amount still required at the 10-year mark Step 5: Compute the shortage/surplus, if any, and compute the required monthly savings between years 11 through 20.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.7: Decisions Involving The Time Value Of Money

Problem 16P

See similar textbooks

Related questions

Q: A cost benefit analysis (also known as a benefit cost analysis) is a process by which organizations…

A: Cost-benefit analysis embodies a methodical and numerical approach utilized to assess the viability…

Q: Donald Harris received a windfall and needs to invest it for tax reasons. He went to his…

A: Given data, Future Air Traffic Strategies Major Downturn Downturn Upturn Major Upturn…

Q: Round your answers to the nearest dollar. Scenario Total Cost for Three Years Keep the old car $…

A: A Small introduction about Maintenance "During the life cycle of an object, maintenance is the…

Q: Southern Gas Company (SGC) is preparing to make a bid for oil and gas leasing right in a newly…

A: Find the Given details below: Given details: SGC - Bid High Bid Low Bid 16 M 7 M…

Q: $2.7 million. the cost of goods sold is estimated to be 40 percent of sales, and corporate overhead…

A: Conclusion:The decision ultimately depends on whether the company values the liquidity and lower…

Q: Suppose your organization is deciding which of THREE projects to bid on. The information or each is…

A: Given data is

Q: A property's annual property taxes equaled $7,560. The seller owes the buyer for 20 days of prorated…

A: The objective of this question is to calculate the amount the seller owes the buyer for 20 days of…

Q: David works for Wool garments company as a production manager. He often participates in the annual…

A: As per the facts of the case, David is responsible for submitting the department’s budgeted…

Q: Consider the following information for the Alachua Retirement Fund, with a total investment of $4…

A: See the answer in the explanation field.Explanation:Answer information:Step 1:Q1.The required rate…

Q: Pls help ASAP on both

A: For the first scenario with JJ and Jim, the most appropriate option is: c. Include this in the…

Q: Mavis Wanczyk (53) of Chicopee, MA was the sole winner of the $758.7 million Powerball jackpot on…

A: Given: Amount = $7,58,700,000 (758.7 Million) Rate of interest ( i ) = 5% Time ( n ) = 30 annual…

Q: What is the probability that the satellite described in Solved Problem 4 will fail between 5 and…

A: P (5 years < failure< 12 years) = P (failure after 5 years) - P (failure after 12 years) Using…

Q: A borrower took out a $1,450,000 30-year fully amortizing conforming adjustable rate mortgage loan…

A: The objective of this question is to calculate the monthly payment for the second year of an…

Q: 4. "Family Man," a construction company, is considering whether to bid on a contract for a new…

A: a)

Question

Note:

To provide coherence and organization to your work, arrange your work for this question as follows:

Step 1: Convert both EARs to annual nominal rates

Step 2: Compute the amount needed at the 20-year mark from now Step 3: Compute the amount in hand at the 10-year mark from now Step 4: Compute the amount still required at the 10-year mark

Step 5: Compute the shortage/surplus, if any, and compute the required monthly savings between years 11 through 20.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step by step

Solved in 2 steps with 10 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Pls help ASAP for both
A real estate investor has the opportunity to purchase land currently zoned residential. If the county board approves a request to rezone the property as commercial within the next year, the investor will be able to lease the land to a large discount firm that wants to open a new store on the property. However, if the zoning change is not approved, the investor will have to sell the property at a loss. Profits (in thousands of dollars) are shown in the following payoff table: State of Nature Rezoning Approved Rezoning Not Approved Decision Alternative S1 S2 Purchase, d1 590 -160 Do not purchase, d2 0 0 If the probability that the rezoning will be approved is 0.5, what decision is recommended?Recommended decision: What is the expected profit?Expected profit: $ fill in the blank 2 The investor can purchase an option to buy the land. Under the option, the investor maintains the rights to purchase the land anytime during the next three months while learning more…
A farmer is trying to decide if continuing to farm is the correct thing to do. Yields on his fields have been declining over the past several seasons. He has an offer on the table from a corporate farmer to lease his land for the season for $15,000. Whether or not he accepts this offer depends on how well his fields will produce and the market value of his crops. If yield is high, the farmer will make $50,000 and there is a 10% possibility of this occurring. If yield is medium, the farmer will make $20,000 and there is a 50% possibility of this occurring. If yield is low, the farmer will make $12,000 and there is a 40% possibility of this occurring. Draw a decision tree for this problem. What should the farmer do according to the decision tree? If the farmer could get more information that would help him predict his yield, what is the maximum amount that he should pay for this information?
A retailer must decide whether to build a small or a large facility at a new location. Demand at the location can be either low or high, with probabilities estimated to be 0.4 and 0.6, respectively. If a small facility is built and demand proves to be high, the manager may choose not to expand (payoff = $223,000) or to expand (payoff = $270,000). If a small facility is built and demand is low, there is no reason to expand and the payoff is $200,000. If a large facility is built and demand proves to be low, the choice is to do nothing ($40,000) or to stimulate demand through local advertising. The response to advertising may be either modest or sizable, with their probabilities estimated to be 0.3 and 0.7, respectively. If it is modest, the payoff is estimated to be only $20,000; the payoff grows to $220,000 if the response is sizable. Finally, if a large facility is built and demand turns out to be high, the payoff is $800,000.Draw a decision tree. Then analyze it to determine the…
You drive a 4 year old truck valued at $15,000. You have a $70,000 personal automobile policy with $12,000 per-person medical payments coverage and both collision ($500 deductible) and comprehensive coverage. Your neighbor drives a five-year old SUV valued at $10,000. Your neighbor has a 25/50/15 automobile policy with $15,000 in medical payments coverage and both collision ($200 deductible) Early one morning your neighbor was driving down the street while you were driving the opposite way to drop your friend off at her house and your neighbor swerved into your lane and struck your vehicle. Below you will find the damage caused by the accident:Your Bodily Injury: $7,000Your Friend’s Bodily Injury: $25,000Your Car: $8,500Neighbor’s Bodily Injury: $3,000Neighbors Car: $9,000Using the information above, find the following:a) How much will your policy pay for your bodily injury? blank1 - Numeric Answer Please type your answer to submit b) How much will your policy pay for your…
Option 2: Raise prices by 50%. If this occurs, there is a 75% chance that an Entrepreneur will set up in competition this year. The board’s estimate of its annual profit in this situation would be as follows: 2A: With new competitor 2B: Without new competitor Probability Profit (Sh.) Probability Profit (Sh.) 0.25 150,000 0.5 200,000 0.5 120,000 0.3 150,000 0.25 80,000 0.2 100,000 Option 3: Expand the car park quickly at a cost of Sh. 50,000 keeping prices theSame. The profits are then estimated to be like 2B above, except that the probabilities would be 0.6, 0.3 and 0.1 respectively. Required: Draw a decision tree for the above problem, including all the relevant data. Using expected values analyze the decision tree and recommend the best option to the owners of the car park.
A store owner must decide whether to build a small or a large facility at a new location. Demand at a location can be either small or large, which probabilities estimated to be 0.4 and 0.6, respectively. If small facility is built and demand proves to be high, the manager may choose not to expand (payoff=P235,000) or to expand (payoff=P275,000). If a small facility is built and demand is low, there is no reason to expand and the payoff is P220,000. If a large facility is built and demand proves to be low, the choice is to do nothing (P60,000) or to stimulate demand through local advertising. The response to advertising may be either modest or sizable, with their probabilities estimated to be 0.3 and 0.7, respectively. If it is modest, the payoff grows to P230,000 if the response is sizable. Finally, if a large facility is built and demand turns out to be high, the payoff is P900,000.a.) Draw a decision tree.b.) Determine the expected payoff for each decision and event node.c.)…
A company is considering either (1) purchasing equipment for use on a new project (purchase cost = $5,000; purchase variable cost = $50 per day) or (2) leasing this equipment from a vendor at a rate of $100 per day. An initial analysis determined that the “purchase” option break-even point is 100 days. Based on this analysis, the company should Lease the equipment if the expected project is expected to last more than 100 days Purchase the equipment if the expected project is expected to last less than 100 days Purchase the equipment if the expected project is expected to last more than 100 days No answer text provided.
Given the following payoff table with the profits ($m), a firm might expect alternative investments (A, B, C) under different levels of interest rate. (Attached)(a) Which alternative should the firm choose under the maximax criterion? (b) Which option should the firm choose under the maximin criterion? (c) Which option should the firm choose under the LaPlace criterion? (d) Which option should the firm choose with the Hurwicz criterion with α = 0.2? (e) Using a minimax regret approach, what alternative should the firm choose? (f) Economists have assigned probabilities of 0.35, 0.3, and 0.35 to the possible interest levels 1, 2, and 3 respectively. Using expected monetary values, what option should be chosen and what is that optimal expected value? (g) What is the most that the firm should be willing to pay for additional information? Use Expected Regret (h) Use the alternative method to verify EVPI Part 2 Assume now that the pay offs are costs answer the following: (a) Using an…
An entertainment manager has to organize a concert and is offered the options of doing it outdoors or in a covered pavilion. The benefits will depend on the attendance of the public and this in turn on the weather, which can be rainy, cloudy or sunny. The expected results if you organize it outdoors are 10,000, 50,000 and 65,000 euros if the weather is rainy, cloudy or wave respectively. If the concert is held in a covered pavilion, the results would be 45,000, 40,000 and 35,000 euros for each climatic state. It asks: a) Configure the decision matrix. b) What decision should the employer make if he knows exactly that he will rain that day? c) What decision should the employer make if the Institute of Meteorology confirms that there is a probability of rain of 15% and of clouds of 30%? d) What decision will the employer make in an environment of uncertainty applying all the criteria you know and knowing that the optimism coefficient is 40%?
Last year, Martina opened an investment account with $7200 . At the end of the year, the amount in the account had decreased by 24.5% . How much is this decrease in dollars? How much money was in her account at the end of last year? Decrease in amount: $ Year-end amount: $
This is the same payoff table used in questions 2 and 3. Below is a payoff table that lists four mortgage options: Decision 1-year ARM 3-year ARM 5-year Arm 30-year fixed Rates Rise $66,645 $62,857 $55,895 $52,276 Outcomes Rates Stable $43,650 $47,698 $50,894 $52,276 4) Which of the following decisions has the best average payoff? CA. 3-year ARM B. 1-year ARM CC. 5-year ARM CD. 30-year Fixed Rates Fall $38,560 $42,726 $48,134 $52,276