Can you remake it$?$

Problem $1$: Loan

Duplicate the Loan Calculator model below in your Excel worksheet.

Formulae for cells F$4$ to F$7$ are as per Figure $1.$

Figure $1$

Name all appropriate ells using their labels and reconstruct the formulae replacing cell address

references.

Test by entering assumption inputs to cells C $4$ to C $7$ using input examples in Figure $2.$

Format the whole model as per Figure $2$ including:

a$.$ Model title font set to $12$ points bold and merge$-$centred $($B$1$:F$1)$

b$.$ "Initial Assumptions" and "Result" merge$-$centered across $2$ columns with Thick Outside

Borders; other data with All Borders

c$.$ Format values appropriately as Number, Currency, or Percentage

d$.$ Color fill areas with different colors of your choice

e$.$ Bold$-$face displayed data

Figure $2$ Problem solutions must make full use of defined name ranges using the labels indicated for each

cell$/$range$.$ Excepting Problem $4$: Forecasting, cell addresses should not be used in the formulas.

RECOMMENDED: Solve each assignment problem below by following the $5$ problem$-$solving steps below

Understand the problem clearly $-$ read the problem instruction carefully more than once.

Strategize $-$ begin by thinking roughly as to how the problem can be solved $-$ write your ideas

out in words.

Design solutions$-$ write a more structured algorithm or draw a flow chart of the ordered set of

steps required to solve the problem.

Implement $-$ translate your design algorithm to formulae that Excel can execute $-$ use

appropriate functions and name$-$defined cell ranges for full credit.

Verify $-$ ensure that the results of your formulae match the example values.

MAIN TASK: READ CAREFULLY BEFORE PROCEDING

Create one Excel Workbook containing separate worksheets to each of the problems below.

Save the workbook as your full name, e$.$g$.,$ anna$\_$watson.xlsx $($all lowercase$).$ Be sure to save

your workbook as a normal Excel workbook file with $.$xlsx extension. To confirm, after the

submission, download your file into a new location on your computer $($or $-$ better $-$ another

computer$)$ and try to open it$.$ If it opens in Excel, you're probably fine.

Each problem must be solved in its own worksheet within one workbook, so rename each sheet

tab with the specific problem title, e$.$g$.,$ Loan, Students, Tiers, etc. $($Ensure to keep everything

compact so that they are easily viewable when opened.$)$

You may use the raw data as provided in the examples and supplementary files to test your

solutions.

Be sure to include all required components in appropriate format for each problem solution.

U of just SALES.Problem $1$: Loan

Duplicate the Loan Calculator model below in your Excel worksheet.

Formulae for cells F$4$ to F$7$ are as per Figure $1.$

Figure $1$

Name all appropriate cells using their labels and reconstruct the formulae replacing cell address

references.

Test by entering assumption inputs to cells C $4$ to C $7$ using input examples in Figure $2.$

Format the whole model as per Figure $2$ including:

a$.$ Model title font set to $12$ points bold and merge$-$centred $($B$1$:F$1)$

b$.$ "Initial Assumptions" and "Result" merge$-$centered across $2$ columns with Thick Outside

Borders; other data with All Borders

c$.$ Format values appropriately as Number, Currency, or Percentage

d$.$ Color fill areas with different colors of your choice

e$.$ Bold$-$face displayed data

Figure $2$ Problem solutions must make full use of defined name ranges using the labels indicated for each cell$/$range$.$