Problem 4.6 (20 Points) Amazon is on a mission to be net zero carbon by 2040....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 4.6 (20 Points) Amazon is on a mission to be net zero carbon by 2040. As part of that endeavor they are considering using autonomous delivery vehicles which operate on alternative power sources (solar, battery, recycled oil, etc). The autonomous vehicles are expected to cost $100,000 each. Amazon wants to invest in 30 to start. Amazon will pay for 30% of the total cost of the autonomous vehicles outright and borrow the other 70 % . The loan is borrowed at 11% for 5 years. Each vehicle is estimated to have a salvage vale of $30,000 after 8 years. The autonomous delivery vehicles are expected to be able to deliver 24/7 and therefore are expected to increase revenue by $50,000 per unit per year and add operating expenses of $10,000 per unit per year. Federal corporate income taxes follow the table below. a) Develop tables using a spreadsheet to determine the ATCF (After Tax Cash Flow) for the 8 years of the AV's considering all 30 AVs. Negative taxable income is treated a $0 taxable income. a. Using straight line depreciation (8 points) b. Using MACRS depreciation with the appropriate property class (8 points) b) If they keep all 30 vehicles for 8 years calculate the Present Worth (PW) of the investment of all 30 vehicles for each method (SL and MACRS) using an after-tax MARR of 9%. (2 points) c) Calculate the IRR of the ATCF. Is this a good investment? (2 points) Tips: Every year's taxable income may not fall in the same tax bracket. If you have a loss in a year assume 0$ taxes paid. You cannot claim depreciation past the salvage value year. When solving for the PV of the after-tax cash flow DO NOT use the NPV formula. You need to make a new column and solve for the PV of each year and then sum them. o The NPV formula solves for net present value in year 0. This formula assumes the first value you select is one period from year 0 and that there is 0$ in year 0. If you really wanted to use it. You could use the NPV formula to solve for years 1-8 and add the year O amount to it. Corporate Income Taxes $ $ $ $ $ $ $ Reported Income $ 50,000.00 $ 75,000.00 $ 100,000.00 $ 335,000.00 $ 10,000,000.00 $ 15,000,000.00 $ $ 50,000.00 75,000.00 100,000.00 335,000.00 10,000,000.00 15,000,000.00 18,333,333.00 18,333,333.00 % Taxes Paid 15.0% 25.0% 34.0% 39.0% 34.0% 35.0% 38.0% 35.0% Problem 4.6 (20 Points) Amazon is on a mission to be net zero carbon by 2040. As part of that endeavor they are considering using autonomous delivery vehicles which operate on alternative power sources (solar, battery, recycled oil, etc). The autonomous vehicles are expected to cost $100,000 each. Amazon wants to invest in 30 to start. Amazon will pay for 30% of the total cost of the autonomous vehicles outright and borrow the other 70 % . The loan is borrowed at 11% for 5 years. Each vehicle is estimated to have a salvage vale of $30,000 after 8 years. The autonomous delivery vehicles are expected to be able to deliver 24/7 and therefore are expected to increase revenue by $50,000 per unit per year and add operating expenses of $10,000 per unit per year. Federal corporate income taxes follow the table below. a) Develop tables using a spreadsheet to determine the ATCF (After Tax Cash Flow) for the 8 years of the AV's considering all 30 AVs. Negative taxable income is treated a $0 taxable income. a. Using straight line depreciation (8 points) b. Using MACRS depreciation with the appropriate property class (8 points) b) If they keep all 30 vehicles for 8 years calculate the Present Worth (PW) of the investment of all 30 vehicles for each method (SL and MACRS) using an after-tax MARR of 9%. (2 points) c) Calculate the IRR of the ATCF. Is this a good investment? (2 points) Tips: Every year's taxable income may not fall in the same tax bracket. If you have a loss in a year assume 0$ taxes paid. You cannot claim depreciation past the salvage value year. When solving for the PV of the after-tax cash flow DO NOT use the NPV formula. You need to make a new column and solve for the PV of each year and then sum them. o The NPV formula solves for net present value in year 0. This formula assumes the first value you select is one period from year 0 and that there is 0$ in year 0. If you really wanted to use it. You could use the NPV formula to solve for years 1-8 and add the year O amount to it. Corporate Income Taxes $ $ $ $ $ $ $ Reported Income $ 50,000.00 $ 75,000.00 $ 100,000.00 $ 335,000.00 $ 10,000,000.00 $ 15,000,000.00 $ $ 50,000.00 75,000.00 100,000.00 335,000.00 10,000,000.00 15,000,000.00 18,333,333.00 18,333,333.00 % Taxes Paid 15.0% 25.0% 34.0% 39.0% 34.0% 35.0% 38.0% 35.0%
Expert Answer:
Related Book For
Posted Date:
Students also viewed these economics questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The two key principles that form the foundation for an ethical sales presentation are OA) the approach and the close B) setting up the appointment and completing the application C) uncovering needs...
-
In 1972, one could buy a bag of chips, a pound of hamburger, a package of buns, and a small bag of charcoal for about $2.50. If the same goods today cost $6.00, then which pair of CPIs would make the...
-
An engine operates on the air standard diesel cycle. The conditions at the start of the compression stroke are \(353 \mathrm{~K}\) and \(100 \mathrm{kPa}\), while at the end of compression stroke the...
-
In a large laboratory electromagnet, the poles have a circular cross section with a diameter of \(100 \mathrm{~mm}\) and are \(25 \mathrm{~mm}\) apart. If there is a uniform 1. 3-T magnetic field...
-
Risk is a major concern of almost all investors. When shareholders invest their money in a firm, they expect managers to take risks with those funds. What do you think are the ethical limits that...
-
15.A ray of light is incident on a slab as shown in figure. The refractive index of medium of slab changes as =1+ y. The angle made by ray with x-axis at y = 2 is 30 0 air 2
-
As the bookkeeper of Phil?s Plowing, you have been asked to complete the entire accounting cycle for Phil from the following information. Use the following chart of accounts. 1. Snow supplies on...
-
The value of perpetuity per year is P10,000 and the annuity is P5,000. What is the rate of interest?
-
As an Ivy Tech student, you are making an investment in your education. This project will look at how hat investment will pay off if you graduate and get a job in your desired field. The median...
-
Eight years ago, Jacqueline de Santos purchased a brand-new condominium at the Toronto Harbourfront for $180,000. Jacqueline had been saving for her first home purchase ever since she graduated from...
-
Big Sur Company manufactures surf boards in a wide variety of sizes and styles. The following incomplete ledger accounts refer to transactions for May: Date Line Item Description Amount Materials...
-
The following are the financial statements of Global Berhad. Global Berhad Statement of Profit or Loss For the year ended 31 December 2021 Revenue Cost of sales Gross profit Operating expenses...
-
Start your QuickBooks Online company. Complete all the hands-on work, step-by-step activities presented on pages 99- 140, and Exercise 3-1 and 3-2 on pages 140-143. To answer the questions below, use...
-
List all possible wave functions when the hydrogen atom is in the 4f quantum state.
-
For each of the following transactions, indicate whether it increases, decreases, or has no effect on the following financial ratios: current ratio, debt-to-equity ratio, profit margin ratio, and...
-
A company uses a predetermined overhead recovery rate based on machine hours. Budgeted factory overhead for a year amounted to 720,000, but actual factory overhead incurred was 738,000. During the...
-
A company has carried out extensive product research and as a result has just launched a new innovative product unlike anything else that is currently available on the market. The company has...
-
A company is planning to launch a new product. The price at which it will sell the product will be determined by the level of competition in the market which is currently uncertain. The possible...
-
A pronghorn, the fastest North American animal, is capable of running at 18 m/s (40 mph) for 10 minutes, after which it must slow down. The time limit isnt because the pronghorn runs out of energy;...
-
When the Glen Canyon hydroelectric power plant in Arizona is running at capacity, 690 m 3 of water flows through the dam each second. The water is released 220 m below the top of the reservoir. If...
-
If you want to jump as high as possible, its best to move downward quickly to a deep crouch, stretching tendons and muscles, before pushing off and leaving the ground rather than simply pushing off...
Study smarter with the SolutionInn App