would be in Class 8 with a CCA rate of 20%. The machinery is expected to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
would be in Class 8 with a CCA rate of 20%. The machinery is expected to have a salvage value of $25,000 after 5 years of use. The new product line would generate incremental sales of 1,450 units per year for 5 years and they are expected to grow 10% per year. The cost per unit is estimated in $75 per unit in the first year. Each unit can be sold for $200 in the first year. The sales price and cost are both expected to increase by 2.5% per year due to inflation. The fixed costs are estimated to be $100,000 at the end of 1 year and would increase with inflation. To handle the new product line, the firm's net operating working capital would be an amount equal to 15% of sales revenues. The firm tax rate is 35%, and its overall weighted average cost of capital (WACC) is 8%. The project is considered by the financial department to be as risky as the company. Requirements 1. Using an Excel spreadsheet: Find the NPV, IRR and discounted payback period (PBP) of the project by using the pro formafinancial statement method to determine cash flows. . Enter the input variables in cells of their own at the top of the spreadsheet (so it is easier to do sensitivity analysis calculations). Set up the necessary equations by referencing to the input variable cells. The would be in Class 8 with a CCA rate of 20%. The machinery is expected to have a salvage value of $25,000 after 5 years of use. The new product line would generate incremental sales of 1,450 units per year for 5 years and they are expected to grow 10% per year. The cost per unit is estimated in $75 per unit in the first year. Each unit can be sold for $200 in the first year. The sales price and cost are both expected to increase by 2.5% per year due to inflation. The fixed costs are estimated to be $100,000 at the end of 1 year and would increase with inflation. To handle the new product line, the firm's net operating working capital would be an amount equal to 15% of sales revenues. The firm tax rate is 35%, and its overall weighted average cost of capital (WACC) is 8%. The project is considered by the financial department to be as risky as the company. Requirements 1. Using an Excel spreadsheet: Find the NPV, IRR and discounted payback period (PBP) of the project by using the pro formafinancial statement method to determine cash flows. . Enter the input variables in cells of their own at the top of the spreadsheet (so it is easier to do sensitivity analysis calculations). Set up the necessary equations by referencing to the input variable cells. The
Expert Answer:
Answer rating: 100% (QA)
Here is the the calculations Inputs A1 Machinery Cost 100000 A2 Salvage Value 25000 A3 Initial Units ... View the full answer
Related Book For
Financial Management Theory and Practice
ISBN: 978-0176517304
2nd Canadian edition
Authors: Eugene Brigham, Michael Ehrhardt, Jerome Gessaroli, Richard Nason
Posted Date:
Students also viewed these accounting questions
-
a. Define "incremental cash flow." 1. Should you subtract interest expense or dividends when calculating project cash flow? 2. Suppose the firm had spent $100,000 last year to rehabilitate the...
-
Amadeus Corporation is considering the issue of a new product to be added to its product mix. They hired you, a recent business graduate from MacEwan, for conducting the analysis. The production line...
-
Did you ever purchase a bag of M&??s candies and wonder about the distribution of colors? Did you know in the beginning they were all brown? Now, peanut M&Ms are 12% brown, 15% yellow, 12% red, 23%...
-
To develop muscle tone, a woman lifts a 2.00-kg weight held in her hand. She uses her biceps muscle to flex the lower arm through an angle of 60.0o. (a) What is the angular acceleration if the weight...
-
New Morning Bakery is in the process of closing its operations. It sold its twoyear- old bakery ovens to Great Harvest Bakery for $600,000. The ovens originally cost $800,000, had an estimated...
-
Should the requirements of the UCC be subject to the application of reliance theories? Go back and review the facts in Case 21-3 about the coal contract. Should silence followed by contract execution...
-
Recognition of Profit and Entries on Long-Term Contract On March 1, 2010, Chance Company entered into a contract to build an apartment building. It is estimated that the building will cost $2,000,000...
-
New parents bring their 3-month-old to the clinic for a rash on the infants head. On examination, the skin affected by the rash is thickened, yellowish white in color, scaly, and looks waxy. In...
-
Manitoba Exporters Inc. (MEI) sells Inuit carvings to countries throughout the world. On December 1, Year 5, MEI sold 10,000 carvings to a wholesaler in a foreign country at a total cost of 600,000...
-
1. How effective is an exculpatory clause in a commercial lease? Discuss when it is limited. 2. Make a list of the precautions tenants should take in negotiations as well as in their operations based...
-
CASE STUDY RECRUITMENT AND SELECTION ABC Computers Solution is Addis Ababa based company having a countrywide network. It is considered as a leading software & hardware supply company having a...
-
Sevall Inc's Mexican Subsidiary, Cancunrocks, is expected to pay Sevall 1 Peso per share in 1 year after all foreign and US taxes have been accounted for. The exchange rate in 1 year is expected to...
-
To claim a deduction for the business use of a personal automobile, the employee must: Review Later Make all entries into a logbook on April 15th The Tax Cuts and Jobs Act eliminated this deduction....
-
Given the following code segment a. (10 points) What is the time complexity of the code segment in terms of big O? b. (10 points) Use dynamic programming to improve the time complexity it the code....
-
You own 1,800 shares of stock in Avondale Corporation. You will receive a $1.80 per share dividend in one year. In two years, the company will pay a liquidating dividend of $80 per share. The...
-
The following critical-thinking questions can be used for class discussion and/or for written assignments to develop communication skills. Be sure to give complete explana- tions for all answers. 1....
-
B made an issue of 150,000 $1 ordinary shares at a premium of 20% the proceeds of which is received by cheque. What is the correct journal to record this? A. Bank Share capital Share premium B. Bank...
-
Calculate Dearborn's: a. Yearly free cash flows to equity b. Cost of equity c. Horizon value using the free cash flow to equity model d. Value of equity and the maximum share price that Brock would...
-
Rework Problem 20-5 using the Black-Scholes model to estimate the value of the option. The risk free rate is 6%?
-
Maritime Construction needs to borrow $50 million for 5 years. The company estimates that the real rate of return is currently 2%, expected inflation per annum for the period is 3%, and the risk...
-
Michael is in his last year of undergraduate studies in human services and economics and is conducting original research for his final research project. As part of his project, he is required to keep...
-
Keza is studying online for a masters degree in Management and wishes to undertake her research project in her home country, Rwanda, where she works as a civil servant. Due to her high pressure job,...
-
You wish to study the reasons why car owners join manufacturer-sponsored owners clubs. You choose to use a qualitative methodology and narrative inquiry research strategy involving unstructured...
Study smarter with the SolutionInn App