Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on information Below Be sure to write the formal report in 3 rd person (dont say we, I, our or us but rather use
Based on information Below
- Be sure to write the formal report in 3rd person (dont say we, I, our or us but rather use statements that talk about the company and the project from a factual, 3rd person perspective.
- Be sure to address the point of this report to get the project teams support in staying on budget and controlling costs so the organization does experience the cash flows as they are projected.
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |
Sales | $8,000,000 | $15,000,000 | $16,000,000 | $18,000,000 | $10,000,000 | $9,000,000 | ||
variable cost | ($2,400,000) | ($4,500,000) | ($4,800,000) | ($5,400,000) | ($3,000,000) | ($2,700,000) | ||
Fixed Cost | ($1,100,000) | ($1,100,000) | ($1,100,000) | ($1,100,000) | ($1,100,000) | ($1,100,000) | ||
Depreciations | ($4,400,000) | ($7,040,000) | ($4,180,000) | ($2,640,000) | ($2,420,000) | ($1,320,000) | ||
EBIT | $100,000 | $2,360,000 | $5,920,000 | $8,860,000 | $3,480,000 | $3,880,000 | ||
Tax @ 35% | ($35,000) | ($826,000) | ($2,072,000) | ($3,101,000) | ($1,218,000) | ($1,358,000) | ||
EAT | $65,000 | $1,534,000 | $3,848,000 | $5,759,000 | $2,262,000 | $2,522,000 | ||
Depreciations | $4,400,000 | $7,040,000 | $4,180,000 | $2,640,000 | $2,420,000 | $1,320,000 | ||
after tax cash flows | $3,120,000 | |||||||
Free cash flows | $4,465,000 | $8,574,000 | $8,028,000 | $8,399,000 | $4,682,000 | $6,962,000 | ||
Capital Expenditures | ($22,000,000) | |||||||
Working capital | ($3,000,000) | |||||||
PV factor 12.22% | 1 | 0.891106755 | 0.794071248 | 0.707602253 | 0.630549147 | 0.561886604 | 0.500700948 | |
PV of cash flows | ($25,000,000) | $3,978,792 | $6,808,367 | $5,680,631 | $5,295,982 | $2,630,753 | $3,485,880 | |
NPV | $2,880,405 | |||||||
IRR | 16.13% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started