IS$300$ for Spring $2024$

Management Information Systems $-$ Homework $3$ on Excel Lesson $2$

Learning Objectives: Spreadsheet Modeling and Analysis Using Excel

What if Analysis Using Scenario Manager

What if Analysis Using Goal Seek

Estimating Revenue with Markdowns

Determining Future Value of retirement investments

Determining Present Value of Investment goals and College Tuition

Determine your grades, estimating the overall semester grade

This homework assignment uses the following Excel file found on Canvas under Week $10.$ File

Excel Lesson $2$ for Homework $3$ Excel Data file. Note: You must turn in an Excel file, no PDF

format will be accepted.

Use the worksheet tab named Problem $1$ Loans in the Excel file.

a$.$ Enter the following data and calculate the Monthly Payment.

b$.$ Perform What$-$If Analysis, using the Scenario Manager. Create the following

scenarios using Row $1$ which is the loan amount of $$700,000$ :

When the scenarios are entered, select summary. Excel will create a new worksheet

named Investment Summary, which will show the results of each scenario in a

table format.

c$.$ Rename the Tab $700$k Scenario for loan. Change the color on the tab color to

Yellow.