Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental accounting principle

Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta

21st edition

1259119831, 9781259311703, 978-1259119835, 1259311708, 978-0078025587

More Books

Students also viewed these Accounting questions

Question

=+2. What do they like better about its competition?

Answered: 1 week ago

Question

=+a. What kind of personality does the brand have?

Answered: 1 week ago