Using Excel (please show all your formulas, calculations and work) Calculate the internal rate of return,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using Excel (please show all your formulas, calculations and work) Calculate the internal rate of return, net present value, payback period, profitability index and total increase in income after taxes for each Option. Assume a weighted average cost of capital of 10%. Option A Purchase of Race Car Additional income Additional expenses Amortization Increase or decrease in income Additional income Additional expenses Amortization Purchase of 350,000 Plane Increase or decrease in income Option C Additional income Additional expenses Amortization Purchase of 150,000 Boat Increase or decrease in income Beginning Investment 220,000 Option B Will be amortized over a 20 year timeline Year 1 Option D Purchase of Horses Additional income Additional expenses Amortization Beginning Investment Increase or decrease in income Beginning Investment Year 1 Beginning Investment 155,000 30,000 15,000 40,000 -25,000 43,750 13,125 8,750 -21,875 Year 1 21,500 5,625 22,500 -6,650 Year 1 111,250 5,562 Year 2 28,250 77,438 60,000 15,000 66,000 -21,000 Year 2 87,500 13,125 8,750 -65,625 Year 2 38,400 5,625 33,000 -225 Year 2 122,562 5,562 36,100 80,900 Year 3 100,000 15,000 62,000 23,000 Year 3 131,250 13,125 8,750 109,375 Year 3 56,150 5,625 31,500 19,025 Year 3 22,625 8,250 33,550 -19,750 Year 4 165,000 15,000 62,000 88,000 Year 4 196,875 13,125 8,750 175,000 Year 4 112,500 5,625 31,500 75,375 Year 4 28,250 10,940 33,550 -19,240 Year 5 200,000 15,000 62,000 123,000 Year 5 262,500 13,125 8,750 240,625 Year 5 84,375 5,625 31,500 47,250 Year 5 11,500 15,100 33,550 -37,150 Using Excel (please show all your formulas, calculations and work) Calculate the internal rate of return, net present value, payback period, profitability index and total increase in income after taxes for each Option. Assume a weighted average cost of capital of 10%. Option A Purchase of Race Car Additional income Additional expenses Amortization Increase or decrease in income Additional income Additional expenses Amortization Purchase of 350,000 Plane Increase or decrease in income Option C Additional income Additional expenses Amortization Purchase of 150,000 Boat Increase or decrease in income Beginning Investment 220,000 Option B Will be amortized over a 20 year timeline Year 1 Option D Purchase of Horses Additional income Additional expenses Amortization Beginning Investment Increase or decrease in income Beginning Investment Year 1 Beginning Investment 155,000 30,000 15,000 40,000 -25,000 43,750 13,125 8,750 -21,875 Year 1 21,500 5,625 22,500 -6,650 Year 1 111,250 5,562 Year 2 28,250 77,438 60,000 15,000 66,000 -21,000 Year 2 87,500 13,125 8,750 -65,625 Year 2 38,400 5,625 33,000 -225 Year 2 122,562 5,562 36,100 80,900 Year 3 100,000 15,000 62,000 23,000 Year 3 131,250 13,125 8,750 109,375 Year 3 56,150 5,625 31,500 19,025 Year 3 22,625 8,250 33,550 -19,750 Year 4 165,000 15,000 62,000 88,000 Year 4 196,875 13,125 8,750 175,000 Year 4 112,500 5,625 31,500 75,375 Year 4 28,250 10,940 33,550 -19,240 Year 5 200,000 15,000 62,000 123,000 Year 5 262,500 13,125 8,750 240,625 Year 5 84,375 5,625 31,500 47,250 Year 5 11,500 15,100 33,550 -37,150
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations in Excel for each option Option A Year Beginning Balance Cash In Cash Out ... View the full answer
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date:
Students also viewed these finance questions
-
The 9/11 terrorists attacks in the United States will lead to more sophisticated export controls. True False
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Students will present a draft IMC strategy for a start-up company and be asked to analyze its potential effectiveness, identifying gaps and making recommendations for improvement of the strategy....
-
Why are locker rooms one of the most important areas in a fitness facility in terms of design, function and cleanliness?
-
Zappy Kitchens manufactures a range of household products. Susan Masters, the company's management accountant, plans to implement a standard costing system. Masters has collected information from...
-
To what extent and for what reasons do you think disclosure levels in stock markets around the world are likely to change during the next ten years? In the context of increasing competition for...
-
Cole Petroleum has spent $206,000 to refine 63,000 gallons of petroleum distillate, which can be sold for $6.30 a gallon. Alternatively, Cole can process the distillate further and produce 53,000...
-
Suppose that x follows a chi-square distribution with 28 degrees of freedom. Use the ALEKS calculator to answer the following. (a) Compute P(20x43). Round your answer to at least three decimal...
-
In early 20X1, Mr. Carpet purchased $200,000 of common shares in a company listed on thelocal stock exchange, with an annual eligible dividend of $5,000. The current fair market value of the shares...
-
Tamarisk Inc. reports the following pretax income (loss) for both financial reporting purposes and tax purposes. Pretax Income Year (Loss) Tax Rate 2018 $128,000 17% 2019 118,000 17% 2020 (290,000)...
-
Select any two MNEs (Multinational Enterprises) from the same industry and evaluate their strategic and operational approach to International and Global HRM. This includes their full suite of IHRM...
-
When you apply for a job in the field of education, you will frequently be asked to include your philosophy of education in the portfolio. In addition, you will likely be asked by potential or...
-
Question 7. List and briefly explain Marshall's four conditions. Using Marshall's conditions, analyze the effect on union power of the unites states Mexico Canada agreement (USMCA) which replaced the...
-
What is the 6 times 6 rule as it pertains to the contents on the actual slide? What is your plan in breaking down your information into smaller parts to work this rule? What will you do when you want...
-
The portion of a group purchase of $ 6 4 0 , 0 0 0 allocated to land when the land is appraised at $ 1 7 0 , 0 0 0 and the buikding on the land is appraised at $ 5 1 0 , 0 0 0 is?
-
The Evanec Company's next expected dividend, D 1 , is $3.39; its growth rate is 6%; and its common stock now sells for $33.00. New stock (external equity) can be sold to net $26.40 per share. What is...
-
A 20-cm-square vertical plate is heated to a temperature of 30oC and submerged in glycerin at 10oC. Calculate the heat lost from both sides of the plate.
-
Amy Hirt started a paper route on January 1, 2009. Every three months, she deposits $300 in her bank account, which earns 8 percent annually but is compounded quarterly. On December 31, 2012, she...
-
Why is interest expense said to cost the firm substantially less than the actual expense, while dividends cost it 100 percent of the outlay?
-
Compute the cost of not taking the following trade discounts: a. 2/10, net40 b. 2/15, net30 c. 2/10, net45 d. 3/10, net180
-
What are some of the major reasons why a business or accounting student should be interested in international business?
-
Why are Japanese companies among the largest in the world?
-
What are some of the different ways in which a firm can get involved in international business?
Study smarter with the SolutionInn App