Question: 7 8 perational and admin expenses will increa 9 * The plan is to O 10 11 our average loan intere 12 5 For deposits,

 7 8 perational and admin expenses will increa 9 * The

plan is to O 10 11 our average loan intere 12 5

7 8 perational and admin expenses will increa 9 * The plan is to O 10 11 our average loan intere 12 5 For deposits, the interest we paid to our cu 13 14 15 ABC BANK 16 17 Balance Sheet 18 2022 FORECAST 19 Jan 20 21 22 Assets Loans Monthly Growth Balance Interest rate (per year) 23 0% $50,000,000 5.00% 24 25 26 27 Liabilities Monthly Growth Deposits Interest rate (per year) 28 0% $75,000,000 1.00% 29 30 31 32 33 34 Income Statement 35 2022 FORECAST Jan $208,333 36 Loan Interest Income 37 38 39 Deposits Interest Expense Operations and Admin Expense $62,500 15,000 40 41 42 Net Income (Profit or Loss) 130,833 43 44 45 46 47 48 49 50 51 52 53 Forecast Guidelines : Do a 12 month forecast (Jan 2022 to Dec 2022) using the following budget guidelines 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 prationalan i min expenses will increase by $750 every month OO 4 The plan is to ar 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 ch 7 8 perational and admin expenses will increa 9 * The plan is to O 10 11 our average loan intere 12 5 For deposits, the interest we paid to our cu 13 14 15 ABC BANK 16 17 Balance Sheet 18 2022 FORECAST 19 Jan 20 21 22 Assets Loans Monthly Growth Balance Interest rate (per year) 23 0% $50,000,000 5.00% 24 25 26 27 Liabilities Monthly Growth Deposits Interest rate (per year) 28 0% $75,000,000 1.00% 29 30 31 32 33 34 Income Statement 35 2022 FORECAST Jan $208,333 36 Loan Interest Income 37 38 39 Deposits Interest Expense Operations and Admin Expense $62,500 15,000 40 41 42 Net Income (Profit or Loss) 130,833 43 44 45 46 47 48 49 50 51 52 53 Forecast Guidelines : Do a 12 month forecast (Jan 2022 to Dec 2022) using the following budget guidelines 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 prationalan i min expenses will increase by $750 every month OO 4 The plan is to ar 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 ch

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!