Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Information in Inputs: Shrieves Casting Company is considering a new project. They expect to sell 1,800 units each year for three years at a price

image text in transcribed
Information in Inputs: Shrieves Casting Company is considering a new project. They expect to sell 1,800 units each year for three years at a price of $200 per unit. Variable costs are $80 per unit and fixed costs are $50,000 per year. The equipment costs $200,000, plus $10,000 of shipping and $30,000 of installation. it will be depreciated according to MACRS 3 year class. When the project ends in three years, Shrieves expects to sell the equipment for $100,000. This project requires an initial investment in net working capital, specifically $40,000 of inventories with $4,000 of Accounts Payable to help finance these inventories. In the inputs, numbers you need to calculate are shown in yellow. Make sure you use cell references! Then fill in all outputs, beginning with the Depreciation schedule, then the rest of the spreadsheet. You will first assume inflation is zero. Make sure your cash inflow and cash outflows are notated differently. Use the functions an Excel to find NPV, IRR and MIRR. Use the if function to put "Accept" or "Reject" in 875

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modeling the Dynamics of Life Calculus and Probability for Life Scientists

Authors: Frederick R. Adler

3rd edition

840064187, 978-1285225975, 128522597X, 978-0840064189

More Books

Students also viewed these Mathematics questions

Question

What is a process? Give an example of an organizational process.

Answered: 1 week ago