Company Express S. A. asks you to construct cash flows for following three (3) investment projects,...

Transcribed Image Text:

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 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