Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please post the answers and the excel formuals for each answer. also pay attention to the lettersumbers for each cell! The Lost in 5 pace

Please post the answers and the excel formuals for each answer. also pay attention to the lettersumbers for each cell! image text in transcribed
The Lost in 5 pace comporation is trying to finaly build a space ship that won't end up stranding everyone on it in some random part of the galaxy. To do so they are considering a new three-year project that will require an initial investrment of $55 milion. These initial assets will be depreciated straight-line to zero over their three-year tax life. The firm will be able to sell these assets at the end of the project for $10,500,750. The project is estimated to generate the following revenues during it's three year life: 518,600,235 in year one, $20,975,410 in year two, and $23,412,000 in year three. The firm expects that their costs will be equal to 60% of the projects some year revenues. They expect that project net working capital (in the form of imventory required) will be equal to 14.50% of the next year's revenue. The firms tax-rate is 21%. What are the project's cash flows from assets for years 03 ? What is the IFR on this project

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

More Books

Students also viewed these Finance questions