Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Company Express S . A . asks you to construct cash flow for following investment project, containing following information: a . Sales ( in $

Company Express S. A. asks you to construct cash flow for following investment project, containing following information:
a. Sales (in $):
Year 1: 90,000
Year 2: 55,000
Year 3: 75,000
Year 4: 190,000
b. Cost of sales is estimated at 53% of sales.
c. Depreciation for year is $15,000 per period (period 1 to 3). In year 4 there is a sale of machinery that results in a gain on sale of non-current assets of $9,800. Total depreciation for year 4 is $12,500.
d. Administrative expenses are equivalent to 17% of sales.
e. In period 0 there is an investment of $58,000.
f. There is credit financing of $32,000 which is amortized in equal
parts of $8,000 per period with a financial expense of $3,700 per
period.
g. There is an investment in working capital of $24,000 in period 0,
which is recovered in period 4.
h. In period 4 there is an investment in land of $40,000.
i. Income tax rate is 17%.
Calculate: cash flow per period. Please use an Excel spreadsheet. Thanks
image text in transcribed

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

Focus On Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes

2nd Edition

0073530638, 9780073530635

More Books

Students also viewed these Finance questions

Question

Why is the Market considered a "Morally Free" zone? (10 Points)

Answered: 1 week ago