Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is in EXCEL Please A widget factory has the following parameters: -Factory Construction Cost: $150,000 / 1,000 widgets of annual production capacity -Annual Production

This is in EXCEL Please A widget factory has the following parameters: -Factory Construction Cost: $150,000 / 1,000 widgets of annual production capacity -Annual Production Capacity: 45,000 widgets/year -Widget Contracted Sale Price: $70 / widget, 2.0% annual price escalation -Factory Operating Expense: $50 / widget, 1.0% annual escalation -Depreciable Basis: 100% of factory construction cost; 100% allocated to 5-year MACRS -Operations Start: December 31, 2017 -Year 1 interest expense: $200,000 -Annual interest rate: 5% -Annual principal amortization: 5% of principal balance 1. Build out a 5-year forecast of levered after-tax widget factory cash flows from the start of operations in excel. Estimate the capital structure used in building this factory. 2. Describe why a buyer with taxable income from other unrelated businesses might value this project differently.

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

The Analysis And Use Of Financial Statements

Authors: Gerald I. White, Ashwinpaul C. Sondhi, Haim D. Fried

3rd Edition

0471375942, 978-0471375944

More Books

Students also viewed these Finance questions

Question

Repeat Problem 9-176 using helium as the working fluid.

Answered: 1 week ago