Forecast Guidelines : Do a 12 month forecast (Jan 2022 to Dec 2022) using the...

60.1K

Verified Solution

Question

Accounting

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
Monthly Growth 0%
Balance $50,000,000
Interest rate (per year) 5.00%
Liabilities
Monthly Growth 0%
Deposits $75,000,000
Interest rate (per year) 1.00%
Income Statement 2022 FORECAST
Jan
Loan Interest Income $208,333
Deposits Interest Expense $62,500
Operations and Admin Expense 15,000
Net Income (Profit or Loss) 130,833

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students