Question: Company Express S. A. asks you to construct cash flows for following three (3) investment projects, containing following information: a. Sales (in Thch$): -

Company Express S. A. asks you to construct cash flows for following

Company Express S. A. asks you to construct cash flows for following three (3) investment projects, containing following information: a. Sales (in Thch$): - 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 Thch$ 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 Thch$ 9,800. Total depreciation for year 4 is Thch$ 12,500. d. Administrative expenses are equivalent to 17% of sales. e. In period 0 there is an investment of Thch$ 58,000. f. There is credit financing of Thch$ 32,000 which is amortized in equal parts of Thch$ 8,000 per period with a financial expense of Thch$ 3,700 per period. g. There is an investment in working capital of ThCh$ 24,000 in period 0, which is recovered in period 4. h. In period 4 there is an investment in land of Thch$ 40,000. . Income tax rate is 17%. Calculate: cash flow per period. Please use an Excel spreadsheet. Thanks

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!