Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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

Step: 3

blur-text-image

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

Exploring Strategic Change

Authors: Julia Balogun, Veronica Hope Hailey, Stafanie Gustafsson

4th Edition

0273778919, 9780273778912

More Books

Students also viewed these Accounting questions

Question

Are assessments of candidate attractiveness relevant? Discuss.

Answered: 1 week ago