Calculating cash flows, after-tax salvage value, NPV and IRR

Input Data from the case:

Equipment cost
Shipping charge
Installation charge
Economic Life
Salvage Value
Tax Rate
Cost of Capital
Units Sold
Sales Price Per Unit
Incremental Cost Per Unit
Inventory/sales
Inflation rate

Don't use plagiarized sources. Get Your Custom Essay on
Calculating cash flows, after-tax salvage value, NPV and IRR
From $8/Page
Order Essay

a. Prepare a depreciation schedule. What is Shrieves’ depreciable basis? What are the annual depreciation expenses?

Annual Depreciation Expense Schedule

Depreciable Basis =

Year % x Basis = Depr. Exp Remaining Book Value
1st
2nd
3rd
4th

b. Construct annual incremental operating cash flow statements.

Annual Operating Cash Flows
1st Year 2nd Year 3rd Year 4th Year
Units
Unit price
Unit cost

Sales
Costs
Depreciation
Operating income before taxes (EBIT)
Taxes (40%)
Net operating profit after taxes
Depreciation
Net Operating Cash Flow (CF)

c. Estimate the required net operating working capital for each year, and the cash flow due to investments in net operating working capital.

Annual Cash Flows due to Investments in Net Operating Working Capital (NOWC)

Present Period (0) 1st Year 2nd Year 3rd Year 4th Year
Sales
NOWC (% of sales) required
CF (required) due to investment in NOWC

d. Calculate the after-tax salvage cash flow.

After-tax Salvage Value
Based on facts in case:
Salvage Value
Book value
Gain or loss
Tax on Salvage Value
Net Terminal Cash Flow (Salvage CF)

e. Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV and IRR? Do these indicators suggest that the project should be undertaken?

Projected Net Cash Flows

Present Period (0) 1st Year 2nd Year 3rd Year 4th Year
Investment Outlay: Long Term Assets
Net Operating Cash Flow (CF)
CF (required) due to investment in NOWC
Salvage Cash Flows
Net Cash Flows

NPV
IRR

Assessment # 3: Capital Budgeting.
Data Case: Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by Sidney Johnson, a recently graduated MBA. The production line would be set up in unused space in Shrieves’ main plant. The machinery’s invoice price would be approximately $200,000; another $10,000 in shipping charges would be required; and it would cost an additional $30,000 to install the equipment. The machinery has an economic life of 4 years, and Shrieves has obtained a special tax ruling which places the equipment in the MACRS 3-year class. The machinery is expected to have a salvage value of $25,000 after 4 years of use.

The new line would generate incremental sales of 1,250 units per year for four years at an incremental cost of $100 per unit in the first year, excluding depreciation. Each unit can be sold for $200 in the first year. The sales price and cost are expected to increase by 3% per year due to inflation. Further, to handle the new line, the firm’s net operating working capital would have to increase by an amount equal to 12% of sales revenues. The firm’s tax rate is 40 percent, and its overall weighted average cost of capital is 10 percent. Prepare a capital budgeting analysis and answer the following questions.

a. Prepare a depreciation schedule. What is Shrieves’ depreciable basis? What are the annual depreciation expenses?

b. Construct annual incremental operating cash flow statements.

c. Estimate the required net operating working capital for each year, and the cash flow due to investments in net operating working capital.

d. Calculate the after-tax salvage cash flow.

e. Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV and IRR? Do these indicators suggest that the project should be undertaken?

Must show all necessary data points, equations and computations accurately to earn maximum point.

Solution Preview
Please open attachment for solution.

The investment outlay is the cost of the investment …

Solution Summary
This solution is comprised of detailed calculation using excel of annual cash flows, after-tax salvage value of the asset, projected net cash flows, the net present value (NPV), and internal rate of return (IRR).

To continue with the answer check on topwriters4me.com/

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 20% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Top Writers 4Me
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 10k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Mathematics
Thank you, great work!
Customer 452483, July 19th, 2021
Communications
EXCELLENT JOB!!! VERY PLEASED :)
Customer 452483, July 5th, 2021
Microbiology
Thank you so much for revising this paper for me. It looks great, truly appreciate it! You're awesome :)
Customer 452483, September 14th, 2021
Healthcare Writing & Communications
Perfect! Thank you so much for all of your help!
Customer 452483, October 31st, 2021
Nursing
Good job! Thank you
Customer 452487, October 17th, 2021
English 101
This writer was very quick with the draft and even faster with the revision! Thank you!
Customer 452603, May 30th, 2022
Psychology
Thank you so much for all of your hard work & help! It’s perfect! Appreciate it!!
Customer 452483, September 11th, 2021
English 101
Great work! Thanks!
Customer 452567, August 2nd, 2022
Nursing
Excellent. Thank you.
Customer 452487, August 26th, 2021
English 101
Perfect! Very informative! Appreciate all of your hard work! Thank you very much.
Customer 452483, September 22nd, 2021
Nursing
Good job! Thank you.
Customer 452487, October 26th, 2021
Psychology
On point! Appreciate all the hard work!!
Customer 452483, August 16th, 2021
1159
Customer reviews in total
96%
Current satisfaction rate
2 pages
Average paper length
47%
Customers referred by a friend
OUR GIFT TO YOU
20% OFF your first order
Use a coupon TOP20 and enjoy expert help with any task at the most affordable price.
Claim my 20% OFF Order in Chat
Open chat
Chat with us Live Here
Get in Touch with Our Live Chat Agents via WhatsApp on +1(346) 416-0954. Get Unlimited Access to Answers on Any Queries With Your Paper.