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

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…
Problem 2: You go to the racetrack and are choosing between 2 horses: Belle and Jeb (you are at the racetrack, so you will bet on one of these two horses). Betting on either horse will cost you $1, and the payoffs are as follows: • Bet on Belle: you will be paid $2 if she wins (or a net profit of $1). You believe she has a 75% chance of winning. • Bet on Jeb: you will be paid $9 if he wins (for a net profit of $8). You believe that he has a 20% chance of winning. Prior to making your decision of which horse to bet on, someone comes and offers you gambler’s “insurance.” If you agree to the gamblers “insurance,” they pay you $1 immediately and you agree to pay them 50% of the profit on your winnings (that is, $0.50 if Belle wins, and $4 if Jeb wins). What should you do? Answer this question by: a) Creating a decision tree for this scenario, making sure you label all branches and include all probabilities and consequences. b) Solving the decision tree using EMV and stating the optimal…
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.)…
David works for Wool garments company as a production manager. He often participates in the annual budgeting process of the company. David is requested by the Chief Executive Officer Linda to submit his department’s budgeted production for the following year. Linda reviews and typically adds 10 percent to the production budget provide by David. The new amount becomes David’s target production level for the following year. David can receive a cash bonus if his department exceeds the projected production level. Explain any incentive that David might have to be dishonest with Linda about the production level he thinks the department can achieve.
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.
A small strip-mining coal company is trying to decide whether it should purchase or lease a new clamshell. If purchased, the “shell” will cost $152,500 and is expected to have a $50,000 salvage value after 6 years. Alternatively, the company can lease a clamshell for only $16,000 per year, but the lease payment will have to be made at the beginning of each year. If the clamshell is purchased, it will be leased to other strip-mining companies whenever possible, an activity that is expected to yield revenues of $9,000 per year. If the company’s MARR is 13% per year, should the clamshell be purchased or leased on the basis of a future worth analysis? Assume the annual M&O cost is the same for both options. The future worth when purchased is $ The future worth when leased is $
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…