excel assignment

profilerfeliz12
NP_EX19_EOM2-1_RichardFeliz_1.xlsx
Home>Business & Finance homework help>Accounting homework help>excel assignment

Documentation

New Perspectives Excel 2019 | Module 2: End of Module Project 1
First Mittagong Community Bank
FORMATTING WORKBOOK TEXT AND DATA
Author: Richard Feliz
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Mortgage

First Mittagong Community Bank
Mortgage Interest Rates
Effective date 11/21/21
Product Rate Points APR
30-Year Fixed 0.05875 1 0.06044
0.06 0.5 0.06127
0.06125 0 0.06209
20-Year Fixed 0.05625 1 0.05852
0.0575 0.5 0.05919
0.05875 0 0.05986
15-Year Fixed 0.0525 1 0.05532
0.05375 0.5 0.05584
0.055 0 0.05635
10-Year Fixed 0.0525 1 0.05657
0.05375 0.5 0.05676
0.055 0 0.05695

Money Market

First Mittagong Community Bank
Tiered Money Market Interest Rates
Tier Minimum Maximum Rate
1 0 2000 0.045
2 2000.01 5000 0.03
3 5000.01 10000 0.02
4 10000.01 50000 0.01
5 50000.01 none 0.005