Desperately need help with finance homework!
Question 3:
Your firm has the opportunity to enter into a new market. The new opportunity is expected to generate revenues of $2.5 million the first year with sales expected to grow by 7% per year for four years. The entire project lasts five years and requires an initial investment in fixed assets of $2.75 million. The project also requires an initial investment of $85,000 in net working capital which will be recovered at the end of the project. Based on your research, variable costs account for 68% of revenues and fixed costs are $105,000 each year. The fixed asset classifies as a 7-year asset and will be depreciated using MACRS. Your marginal tax rate is 35%, your required rate of return is 18%, and you need to get paid back your start-up costs within 4 years. You believe you can salvage the asset for $500,000 at the end of the project and you don’t plan to use debt financing.
Year | Depreciation Rate |
1 | 16.67% |
2 | 22.22% |
3 | 19.44% |
4 | 13.89% |
5 | 11.11% |
6 | 8.33% |
7 | 5.56% |
8 | 2.78% |
Prepare the Pro Forma Income Statements for the next five years and estimate operating cash flow for each year.
Calculate the book value of the fixed asset and the after tax salvage value.
What is the cash flow from assets for each year?
What is the net present value?
What is the IRR?
What is the payback period?
Based on the answers to d-f above should you accept this project?
Question 4:
Your firm has two mutually exclusive 3-year projects and a required rate of 16%.
Cash Flows | Project A | Project B |
Revenues Generated | Start at $100,000 and increase by $100,000 each year | Start at $120,000 and increase by $120,000 each year |
Spending on Fixed Assets | $30,000 | $40,000 |
Useful Life | 5 years | 6 years |
Variable Costs | 20% of Revenues | 25% of Revenues |
Tax Rate | 30% | 30% |
Salvage Value | $12,000 | $12,000 |
NWC Required | $8,000 | $12,000 |
Fixed Costs | $40,000 | $40,000 |
Write down the Pro Forma Income Statements
Write the Cash Flows Table
Find the Book Value and After tax salvage value
What is the IRR of each project?
What is the NPV of each project?
What is the crossover point?
Which project should you choose?
13 years ago
15
Purchase the answer to view it

- excel_solution.xlsx
- baber makayla
- ACC 557 Week 11 Chapter 14 Quiz
- BUS 433 Week 3 Strategy Change Paper ( BUS 433 Week 3 Strategy Change ) ( BUS433 Week 3 Strategy Change Paper )
- Business Law Ch6-10 MCQs Set 2
- Business Law #7 - ORIGINAL WORK (Plagiarism Free) - DUE TONIGHT (9/13/13) AT 8PM EST
- Can you write this on the practice of public dueling in america?
- Resources
- Inside trading and Federal securities Laws for Inside Trading
- Gram-Schmidt orthogonalisation
- Assignment: Strategic Analysis and Strategy Evaluation.. Pls note that is a Strategic management module.