Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ple Bank Forecast Model ASGN for Students (1) - Protected View Page Layout Formulas Data Review View Help Soda PDF 11 Creator ED VIBN karches
ple Bank Forecast Model ASGN for Students (1) - Protected View Page Layout Formulas Data Review View Help Soda PDF 11 Creator ED VIBN karches from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Search (Alt+O) Jastreen Kaur Student & Xf Enable Editing A Comments B C D E F G H J 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. M N O + 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 yea 2022 FORECAST Jan recast 5 For deposits, the interest we paid to our 5 ABC BANK 5. T Balance Sheet 2022 FORECAST Loans Monthly Growth Balance Interest rate (per year) $50,000,000 bites Monthly Growth Deposits Interest rate (per year) $75,000,000 1,004 34 Income Statement 122 FORECAST Jan $208.333 Loan Interest Income Deposits Interest Expense 40 Operations and Admin Expe 162,500 15.000 130.833 42 Net Income (Profit or Loss)
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