Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer in excel. Gallatin, Inc., is considering an investment of $368,000 in an asset with an economic life of 5 years. The firm estimates

image text in transcribed

please answer in excel.

Gallatin, Inc., is considering an investment of $368,000 in an asset with an economic life of 5 years. The firm estimates that the nominal annual cash revenues and expenses at the end of the first year will be $248,000 and $73,000, respectively. Both revenues and expenses will grow thereafter at the annual inflation rate of 4 percent. The company will use the straight-line method to depreciate its asset to zero over five years. The salvage value of the asset is estimated to be $48,000 in nominal terms at that time. The one-time net working capital investment of $11,500 is required immediately and will be recovered at the end of the project. All corporate cash flows are subject to a 38 percent tax rate. What is the project's total nominal cash flow from assets for each year? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to the nearest whole dollar, e.g. 32.) Cash flow Year o Year 0 Year 2 Year 3 Year 4 Year 5

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

Quantitative Analysis for Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha

12th edition

133507335, 978-0133507331

More Books

Students also viewed these Finance questions