Question
It is requested to construct the cash flow for the following project with the following information: a: Sales: Ao 1: 90,000; Ao 2: 55,000; Ao
It is requested to construct the cash flow for the following project with the following information:
a: Sales: Ao 1: 90,000; Ao 2: 55,000; Ao 3: 75,000; Ao 4: 190,000.
b. The cost of sales is 53% of sales;
c. Depreciation for the year is Th$ 15,000 per period (periods 1 to 3). In year 4 there is a sale of machinery that generates a profit from the sale of non-current assets of Th$9,800. Sale value of Th$25,000. And total depreciation in year 4 is Th$12,500.
d. Administration expenses are equivalent to 17% of sales. and. In period 0 there is an investment of Th$58,000. F. There is credit financing for Th$ 32,000 that is amortized in equal parts of Th$ 8,000 per period with a financial expense of Th$ 3,700 per period.
g. There is an investment in working capital of Th$ 24,000 in period 0, which is recovered in period 4. h. In period 4 you must invest in land for Th$40,000. Yo. The income tax rate is 17%.
Calculate CASH FLOW PER PERIOD: Please use an Excel spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started