Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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