Enable Editing XV fx B C D E F G H 1 K M N 0 Forecast Guidelines : Do a 12 month forecast (Jan 2022 to Dec 2022) using the following budget guidelines 1 Expect no growth in loans for the first three months and then 5% each month from April to June. It will stay at this level (so 0% growth) until September and then we expect 3% growth from October to the end of the year. 2 For the deposits, we expect a constant growth of 3.25% each month for the entire year 3 Operational and admin expenses will increase by $750 every month 4 The plan is to leave our average loan interest rate at 5% until June and then increase it to 7% for the second half of the year 5 For deposits, the interest we paid to our customers will go up by 0.10% each month for the first six months, and then stay flat (no change) for the rest of the year ABC BANK Balance Sheet 2022 FORECAST Jan Assets loans BANK ABC Forecast Save simple Bank Forecast Mode ADONT File Home Insert Page Layout Formulas Data R PROTECTED VIEW Be careful--files from the Internet can contain y A14 X fx E F 5 For deposits, the interest we paid to our customers 15 ABC BANK 17 Balance Sheet EN 22 44 E22 Nakon 2022 FORECAST Jan 20 Assets Loans 22 Monthly Growth 23 Balance 24 Interest rate (per year) $50,000,000 5.009 096 $75,000,000 1.0096 26 Liabilities 27 Monthly Growth 28 Deposits 29 Interest rate (per year) 30 31 32 33 34 Income Statement 35 36 Loan Interest Income 37 2022 FORECAST Jan $208,333 39 Deposits interest Expense 40 Operations and Admin Expen $62,500 15,000 42 Net Income (Profit or Loss) 130,833 BANK ABC Forecast Ready