Question

In: Finance

Please show work step by step, No Excel. Thank you! Suppose miller motors can either expense...

Please show work step by step, No Excel. Thank you!

Suppose miller motors can either expense or capitalize an asset it has just purchased for $9,000. if it capitalizes the asset, it will depreciate the asset to a book value of zero on a straight line basis of three years. The firm has a marginal tax rate of 38%, and the cost of capital for this asset is 12%. What is the present-value difference to the firm between expensing and capitalizing the asset? Assume the firm will have sufficient income over the next three years to use all possible tax credits.

Solutions

Expert Solution

If the firm treats it as an expense, the whole amount goes into P&L in the first year and the same expense is tax deductible:

Profit and Loss Statement Extract
Gross Profit X
Less: Expense on purchase of an asset 9000
Net profits X-9000
Less: Taxes 38%*(X-9000)
Tax savings 38%*9000= 3420
PV of Tax Savings =9000/1.12
PV of Tax Savings 3053
Profit and Loss Statement Extract Year 1 Year 2 Year 3
Gross Profit X Y Z
Less: Depreciation on Asset =9000/3= 3000 3000 3000
Net profits X-3000 Y-3000 Z-3000
Less: Taxes 38%*(X-3000) 38%*(Y-3000) 38%*(Z-3000)
Tax savings 38%*3000= 1140 38%*3000= 1140 38%*3000= 1140
PV of Tax Savings =1140/(1.12)^1 =1140/(1.12)^2 =1140/(1.12)^3
PV of Tax Savings 1018 909 811

Sum of PV of Tax savings in Case 2: $2738

PV of Tax Savings in Case 1: $3053

Difference= $315

Thus,treating the asset as an expense leads to higher tax savings but the profits will be volatile with very low profits in the 1st year and higher profits in the subsequent years.

The remaining balance of the asset that is capitalised will be shown in the Balance Sheet at Book Value less Accumulated Depreciation


Related Solutions

Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...
Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a...
Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the:             Year 0 1 2 3 4 Cash flow -70,000 30,000 30,000 30,000 20,000 Payback Discounted payback NPV Profitability index IRR MIRR
Please show work step by step, no excel. Thank you! The three alternative projects shown below...
Please show work step by step, no excel. Thank you! The three alternative projects shown below have the expected cash flows that are given, and the cost of capital is 10%. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs. Why are these two sets of rankings different? year 0 1 2 3...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks...
Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks given These following inputs are from Yahoo finance to see how close the model will match the current mkt price. These are 2019 figures: FCF’s = 60 billion             growth= 5%               wacc = 7.5%         Treasury securities = 51 billion     debt = 92 billion            #shares= 4.6 billion Assume the growth rate listed is for the first 4 years and then FCF’s will grow at 3.5% thereafter....
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.
Can you please show how you would solve the following using excel? Step by Step? Kaelea,...
Can you please show how you would solve the following using excel? Step by Step? Kaelea, Inc., has no debt outstanding and a total market value of $117,000. Earnings before interest and taxes, EBIT, are projected to be $8,300 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 23 percent higher. If there is a recession, then EBIT will be 32 percent lower. The company is considering a $41,700 debt issue with...
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
Can you please show me the work on how you get your answer please (thank you...
Can you please show me the work on how you get your answer please (thank you in advance kings and queens of chegg) Problem 1: The following selected information is provided about a manufacturing company: Raw material purchases800,000 Direct labor 415,000 Overhead applied730,000 Actual overhead745,000 Selling and administrative salaries500,000 Other selling and administrative expenses185,000 Sales revenue5,000,000 Inventory data: January 1 December 31Raw material 75,000 100,000Work in process 105,000 140,000Finished goods 120,000 125,000Calculate the cost of goods sold. Assume that under/over...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT