James is planing an investment strategy for a four-year period, which the goal of having the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
James is planing an investment strategy for a four-year period, which the goal of having the largest possible amount of cash on hand after the four years. He has some revenue from a combination of an RESP (registered education savings plan) fund that his parents opened for him when he was a baby, Scholorship funds, and a small inheritance he recently received from his grandmother. His estimate of revenues and expenses over the four years is shown in the following table. James has $5000 in cash at the beginning of the first year. Year 1 2 3 4 Revenues $30,000 $40,000 $25,000 $15,000 Expenses $10,000 $25,000 $25,000 $12,500 Any money left over at the end of a year can be invested in guaranteed investment certificates (GICs) for one year at an annual interest rate of 2.9%, for two years at 3.0%, for three years at 3.1%, and for four years at 3.4%. James uses the following rule for each of the four years: Money Invested + Expenses Paid < Revenues + Money Earned from Investment. (a) Formulate a linear program model to determine an investment strategy that will maximize the value of James's GICs at the end of the fourth year. (b) Solve using either Excel or LINGO and explain the result. Hint: 1) James can have up to four GICs due at the end of the fourth year: a four-year GIC invested at the beginning of year 1, a three-year GIC invested at the beginning of year 2, a two-year GIC invested the beginning of year 3, and a one-yar GIC invested at the beginning of year 4. It is the sum of these values that need to be maximized. 2) A one year GIC will earn 2.9% at the end of one year, so that $1 invested in a 1-year GIC at the beginning of the first year will be worth $1.029 at the end of the first year. Likewise, the value of a 2-year GIC at the end of two years will be the annual rate of 3% compounded over 2 years, namely, 1.0322 = 1.0609. Thus, if $1 is invested in a 2-year GIC at the beginning of year 1, its value at the end of year 2 will be $1.0609. James is planing an investment strategy for a four-year period, which the goal of having the largest possible amount of cash on hand after the four years. He has some revenue from a combination of an RESP (registered education savings plan) fund that his parents opened for him when he was a baby, Scholorship funds, and a small inheritance he recently received from his grandmother. His estimate of revenues and expenses over the four years is shown in the following table. James has $5000 in cash at the beginning of the first year. Year 1 2 3 4 Revenues $30,000 $40,000 $25,000 $15,000 Expenses $10,000 $25,000 $25,000 $12,500 Any money left over at the end of a year can be invested in guaranteed investment certificates (GICs) for one year at an annual interest rate of 2.9%, for two years at 3.0%, for three years at 3.1%, and for four years at 3.4%. James uses the following rule for each of the four years: Money Invested + Expenses Paid < Revenues + Money Earned from Investment. (a) Formulate a linear program model to determine an investment strategy that will maximize the value of James's GICs at the end of the fourth year. (b) Solve using either Excel or LINGO and explain the result. Hint: 1) James can have up to four GICs due at the end of the fourth year: a four-year GIC invested at the beginning of year 1, a three-year GIC invested at the beginning of year 2, a two-year GIC invested the beginning of year 3, and a one-yar GIC invested at the beginning of year 4. It is the sum of these values that need to be maximized. 2) A one year GIC will earn 2.9% at the end of one year, so that $1 invested in a 1-year GIC at the beginning of the first year will be worth $1.029 at the end of the first year. Likewise, the value of a 2-year GIC at the end of two years will be the annual rate of 3% compounded over 2 years, namely, 1.0322 = 1.0609. Thus, if $1 is invested in a 2-year GIC at the beginning of year 1, its value at the end of year 2 will be $1.0609.
Expert Answer:
Answer rating: 100% (QA)
a The linear program model to maximize the value of Jamess GICs at the end of the fourth year can be formulated as follows Let x1 amount invested in a ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these finance questions
-
Ques 1: What is the major complaint by firms concerning the Sarbanes-Oxley act of 2012? A. the legislative maximum allowable compensation for a CEO. B. the legal requirement to disclose project...
-
You are asked to develop a Floppy Disk program that allows users to access a floppy disk locally mounted on a computer. You are expected to use C programming language. In your program, all file I/O...
-
A ball is attached to one end of a wire, the other end being fastened to the ceiling. The wire is held horizontal, and the ball is released from rest (see the drawing). It swings downward and strikes...
-
(a) Which primary alcohol of molecular formula C5H12O cannot be prepared from an alkene? Why? (b) Write equations describing the preparation of three isomeric primary alcohols of molecular formula...
-
A man is delivering a cupboard to a house. a. The man trolls the cupboard at a steady speed from the lorry to the house. The friction force in the wheels is 40 N. State the force with which the man...
-
In an engine working on Otto cycle, air has a pressure of 1.0 bar and temperature \(30^{\circ} \mathrm{C}\) at the entry. Air is compressed with a compression ratio of 6 . The heat is added at...
-
1. Does Red set clear performance standards for George? If he does, what are they? 2. Red and George are both jockeys who competed against each other in earlier races. Do these scenes show peer...
-
Your company has identified $2750 per week of potential savings on your processing line. Your company wishes to deposit these savings into an account that earns 1.15% interest compounded weekly....
-
The L. Young & Sons Manufacturing Company produces two products, which have the following profit and resource requirement characteristics: Last months production schedule used 350 hours of labor in...
-
Suppose that you are quoted the following FC/NZD spot and forward rates: Spot bid-ask p.a. 3 month 6-mo.forward Euro-interest bid-ask p.a. 6 month Euro-interest 3-mo. forward bid-ask NZD...
-
Meteor, Inc. recognized revenue of $ 6 0 0 for the current year, of which $ 1 2 0 was received in cash. The rest of the cash will be collected in the following year. The company incurred expenses of...
-
Worthington Industries sells cookware in France and reports using IFRS. On January 1 , YEAR 0 , Worthington bought a machine to manufacture pans for 2 0 0 , 0 0 0 with a 1 0 year life. Assume that...
-
What are your personal goals related to pursuing your degree: personal fulfillment, finishing something started years ago, good example for your children, advancement at work, etc.? What are your...
-
Mark Wilson resigned from his corporate job on December 1 5 , 2 0 2 1 , to start his sole proprietorship, called Wilson s Consulting. He started on January 1 , 2 0 2 2 . He employed three employees...
-
What are the advantages of continuous stock - takings over the normal annual stock - taking? What is a perpetual inventory? What are the most common methods of pricing stocks?
-
A business owner makes 60 items by hand in 45 hours. She could have earned $35 an hour working for someone else. Her total explicit costs are $225. If each item she makes sells for $18, her economic...
-
The graph of the sequence whose general term is an = n - 1 is which of the following? [8.1] A. B. TITTT 3-2-1 23.45 2.3.4
-
List three qualitative measures of performance.
-
Variance analysis, material and labor Each unit of job Y703 has standard requirements of 5 pounds of raw material at a price of $100 per pound and 0.5 hour of direct labor at $12 per hour. To produce...
-
Briefly explain each of the four steps of the plandocheckact cycle.
-
If the displacement of an object is 300 m north, what can you say about the distance traveled by the object?
-
Speed is the magnitude of velocity. Is average speed the magnitude of average velocity? Explain.
-
The average velocity of a jogger on a straight track is computed to be +5 km/h. Is it possible for the joggers instantaneous velocity to be negative at any time during the jog? Explain.
Study smarter with the SolutionInn App