Prepare forecasted financial statements for Year 7 (cash flow statement) Using past results as a starting point
Question:
Prepare forecasted financial statements for Year 7 (cash flow statement)
Using past results as a starting point prepare a simple cash flow statement. Determine the cash receipts from new deposits and loan repayments and cash disbursements from interest payments to depositors, salaries, wages, taxes and other, cash dividends (assume 7M will be paid for dividends) and new loans to property owners for year 7. To determine how much to lend in year 7-assume you will want to keep $25.5M "on hand". Cash receipts minus cash disbursements will give you the change in cash. You will add the change in cash to beginning cash for year 6 to calculate ending cash in year 7.
Hints:
1. The amount of new term deposits received for year 7 can be estimated by reviewing the change in Term Deposit liability balances on the balance sheet for past years. Determine if you see an incremental increase or decline over the years. Is there a pattern that you can use to project the amount of new deposits in year 7?
465.1
2.Cash receipts from loan repayments can be estimated from the firm’s loan cards for outstanding loans. There are two loans that are repaid in year 7, loans 602 and 603. Assume that the loans, interest, and fees anticipated as being due in year 7 are actually collected. Assume loans are paid off mid-year.
3. Using the new and existing deposits assumed in 1, calculate the interest paid to depositor at prevailing interest rate on term deposits of 11% (provided in the annual report). Assume all interest payable at the end of year 6 was paid in year 7.
Impact to cash:
Interest payable year 6 (paid in year 7)
Interest expense year 7 11% for new and existing term deposits
-Interest payable year 7 (paid in year 8) 25% of interest expense for the year 7 *
* 25% payable amount calculated: interest payable/interest expense year 6 calculated as follows 12.2/48.7=25%. Apply the same percentage (25%) to calculate the interest payable for year 7 above.
4, Salaries, Wages, and Other expenses have been paid as incurred (no accrued liabilities). The amount for year 7 can be estimate by reviewing the trend in expenses for Salaries, Wages, and Other over the past 6 years.
5. Per the Notes to the Financial Statement the information in the annual report indicates that taxes are calculated using cash-basis accounting. Deferred taxes are not immaterial and not recognized in the accounts. The only interest and loan fee income expected to be collected in cash during the year will be from loans 602 and 603. The loan fees and the interest accrued on these loans during prior years are given on the loan cards