Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your assignment is to create an MS Excel spreadsheet related to the following scenario: It s Friday afternoon, and your personal banker, Roberto, at Bank

Your assignment is to create an MS Excel spreadsheet related to the following scenario:
Its Friday afternoon, and your personal banker, Roberto, at Bank of America calls you to discuss your home improvement loan application. You were expecting the call, and you hope he will share good news about qualifying for the loan. Roberto is optimistic that you will qualify for this loan but needs additional information to process the loan.
He says, You are applying for $50,000, and Im sure the improvement you expect to make at home will be great. From you mentioned during our first meeting, you are building an outdoor patio so that you can enjoy more time with family and friends out by the pool. Im very happy for you!
Roberto goes on to explain that the underwriting team needs a bit more information to complete the review process. He asks you to put together an MS Excel spreadsheet detailing your monthly income and expenses. He goes on to say that you credit score of 765 is excellent, and that the personal budget is mostly a formality.
For your assignment, create an MS Excel spreadsheet that meets the following Content Requirements:
Include your monthly income and expenses. Feel free to modify the numbers if necessary. The purpose of this assignment is to work on the MS Excel features and functionality.
Make sure to use at least 5 formulas, such as, addition, subtraction, multiplication, average, and so on. Pleas provide the syntax in the field, such as A2+ B2.
Create borders for budget.
Ensure that some of the content is centered, right aligned, and left aligned.
Use different fonts and font sizes.
Use shading to highlight any part of your budget.

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

F For Quantitative Finance

Authors: Johan Astborg

1st Edition

1782164626, 978-1782164623

More Books

Students also viewed these Finance questions