find the Ending Balance Sheet year 0 and year 1 Cash Receivables Inventories Prepayments Net PP&E Debt Accounts payables Accrued expenses Deferred revenues Paid_in_Capital Retained earnings Analytical balance sheet Operating assets Less: Operating liabilities [Enter as a negative number.] Net operating assets Financial liabilities Equity Less: Financial assets [Enter as a negative number.] Invested capital Income Statement Sales Less: Operating expenses [Enter as a negative number.] Operating profit Financial income Less: Financial expense [Enter as a negative number.] Net income Cash Flow Statement Unlevered free cash flows Less: Interest payments [Enter as a negative number.] Change in financial liabilities Change in paid-in capital (Dividends) [Enter as a negative number.] Interest received (Change in financial assets) [Enter as a negative number.] Return on investment Operating profit margin in % Net operating asset turnover in % ROIC in % Effect of financial liabilities on ROE in % Effect of financial assets on ROE in % [Enter as a negative number.] ROE in % using the question: Assume 0% tax rate. Transactions for Y0 TCo starts with a capital infusion of $40. TCo borrows $80. TCo buys inventory for $55. It pays $30 in cash and promises to pay the remainder later. TCo buys PP&E for $70. TCo prepays $10 in insurance. TCo receives an advance from customers of $20. Transactions for Y1 7. TCo has sales revenue of $145. $17 of the revenue is for making deliveries against the advance it had received earlier; $76 is to be received later 8. The cost of inventory sold is $35. 9. Depreciation for property, plant, and equipment is $27. 10. The cost of employee salaries is $30 of which $13 will be paid later. 11. $5 out of the prepayments are expensed. 12. Interest income is 2% of the cash balance at the end of Y0. 13. Interest expense is 6% of the debt balance at the end of Y0. 14. TCo declares and pays $3 in dividends.
find the Ending Balance Sheet year 0 and year 1 Cash Receivables Inventories Prepayments Net PP&E Debt Accounts payables Accrued expenses Deferred revenues Paid_in_Capital Retained earnings Analytical balance sheet Operating assets Less: Operating liabilities [Enter as a negative number.] Net operating assets Financial liabilities Equity Less: Financial assets [Enter as a negative number.] Invested capital Income Statement Sales Less: Operating expenses [Enter as a negative number.] Operating profit Financial income Less: Financial expense [Enter as a negative number.] Net income Cash Flow Statement Unlevered free cash flows Less: Interest payments [Enter as a negative number.] Change in financial liabilities Change in paid-in capital (Dividends) [Enter as a negative number.] Interest received (Change in financial assets) [Enter as a negative number.] Return on investment Operating profit margin in % Net operating asset turnover in % ROIC in % Effect of financial liabilities on ROE in % Effect of financial assets on ROE in % [Enter as a negative number.] ROE in % using the question: Assume 0% tax rate.
Transactions for Y0
- TCo starts with a capital infusion of $40.
- TCo borrows $80.
- TCo buys inventory for $55. It pays $30 in cash and promises to pay the remainder later.
- TCo buys PP&E for $70.
- TCo prepays $10 in insurance.
- TCo receives an advance from customers of $20.
Transactions for Y1 7. TCo has sales revenue of $145. $17 of the revenue is for making deliveries against the advance it had received earlier; $76 is to be received later 8. The cost of inventory sold is $35. 9. Depreciation for property, plant, and equipment is $27. 10. The cost of employee salaries is $30 of which $13 will be paid later. 11. $5 out of the prepayments are expensed. 12. Interest income is 2% of the cash balance at the end of Y0. 13. Interest expense is 6% of the debt balance at the end of Y0. 14. TCo declares and pays $3 in dividends.
Unlock instant AI solutions
Tap the button
to generate a solution