Understanding Economic Equivalence John Doe just graduated with a B.Eng. in Industrial Engineering and landed a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Understanding Economic "Equivalence" John Doe just graduated with a B.Eng. in Industrial Engineering and landed a new job with a starting salary of $48,000. There are a number of things that he would like to do with his newfound "wealth". For starters, he needs to begin repaying his student loans (totaling $20,000) and he'd like to reduce some outstanding balances on credit cards (totaling $5,000). John needs to purchase a car to get to work and would like to put some money aside to purchase an apartment in the future. Last, but not least, he wants to put some money aside for eventual retirement. Our recent graduate needs to do some financial planning for which he has selected a 10-year time frame. At the end of 10 years, he'd like to have paid off his current student loan and credit card debt, as well as have accumulated $40,000 for a down payment on an apartment. If possible, John would like to put aside 10% of his take home salary for retirement. He has gathered the following information to assist him in his planning: ● ● ● Student loans are typically repaid in equal monthly installments over a period of 10 years. The interest rate on John's loan is 8% compounded monthly. Credit cards vary greatly in the interest rate charged. Typical APR rates are close to 17% and monthly minimum payments are usually computed using a 10-year repayment period. The interest rate on John's credit card is 18% compounded monthly. Car loans are usually repaid over 3, 4, or 5 years. The APR on a car loan can be as low as 2.9% (if the timing is right) or as high as 12%. As a first-time car buyer, John can secure a $15,000 car loan at 9% compounded monthly to be repaid over 60 months. • A 30-year, fixed rate mortgage is currently going for 5.75%-6.0% per year. If John can save enough to make a 20% down payment on the purchase of his apartment, he can avoid private mortgage insurance (PMI) that can cost as much as $60 per month. Investment opportunities can provide variable returns. "Safe" investments can guarantee 7% per year, while "risky" investments could return 30% or more per year. John's parents and older siblings have reminded him that his monthly take home pay will be reduced by income taxes and benefit deductions. He should not count on being able to spend more than 80% of his gross salary. You have been asked to review his financial plans. How reasonable are his goals? [Hint: Since all repayments are done on a monthly basis, it makes sense to adopt the month as John's unit of time. Also, it is best if you follow a "divide and concur" approach, where you analyze his cash flows in terms of separate categories (i.e., segmenting model).] Instructions: As part of your analysis, results, and conclusions, you are asked to provide your friend John with a table that summarizes his monthly financial plan (including income and expenses). You should clearly state your assumptions, if any. Think of this as a realistic problem, where all aspects should be taken into account (think outside the box!). ● ● Students are strongly encouraged to use MS Excel, whenever appropriate, but that's not necessary. If Excel is used, however, please attach the results to your report, as appropriate (and submit an electronic copy of the Excel Sheet). Students should clearly explain and show their work regardless of the approach chosen. Understanding Economic "Equivalence" John Doe just graduated with a B.Eng. in Industrial Engineering and landed a new job with a starting salary of $48,000. There are a number of things that he would like to do with his newfound "wealth". For starters, he needs to begin repaying his student loans (totaling $20,000) and he'd like to reduce some outstanding balances on credit cards (totaling $5,000). John needs to purchase a car to get to work and would like to put some money aside to purchase an apartment in the future. Last, but not least, he wants to put some money aside for eventual retirement. Our recent graduate needs to do some financial planning for which he has selected a 10-year time frame. At the end of 10 years, he'd like to have paid off his current student loan and credit card debt, as well as have accumulated $40,000 for a down payment on an apartment. If possible, John would like to put aside 10% of his take home salary for retirement. He has gathered the following information to assist him in his planning: ● ● ● Student loans are typically repaid in equal monthly installments over a period of 10 years. The interest rate on John's loan is 8% compounded monthly. Credit cards vary greatly in the interest rate charged. Typical APR rates are close to 17% and monthly minimum payments are usually computed using a 10-year repayment period. The interest rate on John's credit card is 18% compounded monthly. Car loans are usually repaid over 3, 4, or 5 years. The APR on a car loan can be as low as 2.9% (if the timing is right) or as high as 12%. As a first-time car buyer, John can secure a $15,000 car loan at 9% compounded monthly to be repaid over 60 months. • A 30-year, fixed rate mortgage is currently going for 5.75%-6.0% per year. If John can save enough to make a 20% down payment on the purchase of his apartment, he can avoid private mortgage insurance (PMI) that can cost as much as $60 per month. Investment opportunities can provide variable returns. "Safe" investments can guarantee 7% per year, while "risky" investments could return 30% or more per year. John's parents and older siblings have reminded him that his monthly take home pay will be reduced by income taxes and benefit deductions. He should not count on being able to spend more than 80% of his gross salary. You have been asked to review his financial plans. How reasonable are his goals? [Hint: Since all repayments are done on a monthly basis, it makes sense to adopt the month as John's unit of time. Also, it is best if you follow a "divide and concur" approach, where you analyze his cash flows in terms of separate categories (i.e., segmenting model).] Instructions: As part of your analysis, results, and conclusions, you are asked to provide your friend John with a table that summarizes his monthly financial plan (including income and expenses). You should clearly state your assumptions, if any. Think of this as a realistic problem, where all aspects should be taken into account (think outside the box!). ● ● Students are strongly encouraged to use MS Excel, whenever appropriate, but that's not necessary. If Excel is used, however, please attach the results to your report, as appropriate (and submit an electronic copy of the Excel Sheet). Students should clearly explain and show their work regardless of the approach chosen.
Expert Answer:
Answer rating: 100% (QA)
Lets calculate the monthly amounts to be paid from Johns salary towards the repay... View the full answer
Related Book For
Ethical Obligations and Decision Making in Accounting Text and Cases
ISBN: 978-1259730191
4th edition
Authors: Steven Mintz, Roselyn Morris
Posted Date:
Students also viewed these general management questions
-
A rather wealthy man decided he would like to arrange for his descendants to be well educated. He would like each child to have $60,000 for his or her education. He plans to set up a perpetual trust...
-
The administrator of a nursing home would like to do a time-and-motion study of staff time spent per day performing nonemergency tasks. Prior to the introduction of some efficiency measures, the...
-
A rather wealthy man decided he would like to arrange for his descendants to be well educated. He would like each child to have $60,000 for his or her education. He plans to set up a perpetual trust...
-
The accounting records for The Skate Shed, Inc., reflected the following amounts at the end of January 2018: Prepare The Skate Shed?s multistep income statement for the fiscal year ended January 31,...
-
The following graph shows possible long-run market supply curves for a perfectly competitive industry. Determine which supply curve indicates a constant-cost industry and which an increasing-cost...
-
Consider each of the following independent situations: Case A Inventory was received and was recorded at the invoice price of $ 56,000. The goods had neither been sold nor paid for at year- end....
-
Use the technique discussed in Section9.4 to develop a GEE approach for zeroinflated Poisson model for count responses in longitudinal studies. Section9.4: 9.4 Marginal Models for Longitudinal Data...
-
Balance sheet data for Bryant company on December 31, the end of the fiscal year, are shown below. Prepare a comparative balance sheet for 2012 and 2011, stating each asset as a percent of total...
-
An l-regular graph, l 1, is a simple graph where all of its vertices have degree l. The union of two simple graphs G G U G2 = (V U V2, E1 U E2). = (V1, E1) and G2 = (V2, E2), is the simple graph Two...
-
In this mini-case you will perform some procedures required as a part of audit planning. For ease your audit manager has already organized the workpapers and completed several of the required...
-
what exactly is an incremental analysis and what are some examples where an incremental analysis might be applied in either the business world or in your personal lives?
-
Trial closes are as important in the B2C environment as they are in the B2B environment. A B2C trial close could be Multiple select question. Can I put this at the register for you? Will you be...
-
What type of deduction is HSA contribution? What is Deduction Itemized and Deduction Standard?
-
You work for the CEO of a new company that plans to manufacture and sell a new product, a watch that has an embedded TV set and a magnifying glass crystal. The issue now is how to finance the...
-
Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?
-
Explain the CONCEPT OF ROUTINE ACTIVITY THEORY INRELATION TO CRIME
-
A student has to earn a total of at least 280 points on four tests in his math class to pass the class, and his total on the first three tests is 197 points. set up an inequality necessary to find...
-
The Dow Jones Industrial Average reached a high of $ 7801.63 on December 29, 1997. Recall from Example 18.4 that it reached a high of $ 1003 on November 14, 1972. The Consumer Price Index for...
-
You are Bill's best friend. Assume he asks for your advice about what he should do. What would you say and why? Support your answer with reference to relevant auditing and/or ethics requirements.
-
How would you handle the issue if you were in Ricardo's position? Develop an action plan to get your point of view across. What would you say? What do you expect the objections or push-back will be?...
-
Consider the role of KPMG in the case with respect to the accounting and auditing issues. How did the firms' actions relate to the ethical and professional expectations for CPAs by the accounting...
-
Smith Company produces and sells one product for $40 per unit. The company has no beginning inventories. Its variable manufacturing cost per unit is $18 and the variable selling and administrative...
-
Which of the following statements is false? (You may select more than one answer.) a. Under variable costing, only those manufacturing costs that vary with output are treated as product costs. b....
-
Smith Company produces and sells one product for $40 per unit. The company has no beginning inventories. Its variable manufacturing cost per unit is $18 and the variable selling and administrative...
Study smarter with the SolutionInn App