Question: 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
 Company Express S. A. asks you to construct cash flow for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!