Use the table to calculate the total retirement savings of each employee based on the following instructions. - In column D write an IF function that uses the contribution guidelines noted in the general information section (customers over 30 years of age and up = 7% all others 5%) and customer age (column B) to calculate each monthly contribution value in column D. Format the results using accounting number format. - In column E Calculate the total savings at retirement based on the quarterly percentage rate (QPR) of 1.25% and the precalculated monthly contributions based on the prior step. Format the results using accounting number format.
Use the table to calculate the total retirement savings of each employee based on the following instructions. - In column D write an IF function that uses the contribution guidelines noted in the general information section (customers over 30 years of age and up = 7% all others 5%) and customer age (column B) to calculate each monthly contribution value in column D. Format the results using accounting number format. - In column E Calculate the total savings at retirement based on the quarterly percentage rate (QPR) of 1.25% and the precalculated monthly contributions based on the prior step. Format the results using accounting number format.
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Use the table to calculate the total retirement savings of each employee based on the following instructions.
- In column D write an IF function that uses the contribution guidelines noted in the general information section (customers over 30 years of age and up = 7% all others 5%) and customer age (column B) to calculate each monthly contribution value in column D. Format the results using accounting number format.
- In column E Calculate the total savings at retirement based on the quarterly percentage rate (QPR) of 1.25% and the precalculated monthly contributions based on the prior step. Format the results using accounting number format.
Transcribed Image Text:exploring2. N360Downl.
Microsoft
New Tab
AutoSave
John_MS100_Assignment5_PMTFV_Start -
O Search
ff
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Finess Data
mments
E Apps
Showdown!
S A Pokémon Calcula..
E Reading list
>>
DATA
EXCEL
- A A
==
ab
Calibri
11
General
EX Delete
Paste
В I U
$ • % 9 58 98
Conditional Format as
Cell
Sort & Find &
Analyze
Sensitivity
A
Formatting v Table v Styles
H Format
Filter v Select v
Data
Pokémon
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Analysis
Sensitivity
no
Trading Car.
A1
fx
General Information
В
D
F
G
H
I
K
1
General Information
RADICAL
2
Retirement Account QPR
1.25%
Retirement age
65
RED
3
>= 30 contribution amount
7%
Contribution increase age
30
4
<30 contribution amount
5%
Monthly Contribution
Annual Salary
21 $ 199,883.00
55 $ 126,528.00
83,189.00
79,200.00
90,874.00
160,118.00
91,388.00
40 $ 156,076.00
54,389.00
80,188.00
62 $ 102,220.00
125,218.00
24 $ 167,899.00
52,301.00
121,907.00
157,136.00
34 $ 169,294.00
$ 127,394.00
44 $ 118,744.00
28 $ 177,865.00
Last Name
Age
Total savings at retirement
Use the table to calculate the total retirement savings of each employee based on the
following instructions.
HW
ALVAREZ
8.
BURKE
MILLS
46 $
In column D write an IF function that uses the contribution guidelines noted in the
general information section (customers over 30 years of age and up = 7% all others 5%)
and customer age (column B) to calculate each monthly contribution value in column D.
Format the results using accounting number format.
10
TERRY
64
$
37 $
41 $
63 $
11
SMITH
РКНЕХ
12
MCKINNEY
13
LAWRENCE
CALDWELL
CHAVEZ
14
33 $
34 $
- In column E Calculate the total savings at retirement based on the quarterly percentage
rate (QPR) of 1.25% and the precalculated monthly contributions based on the prior step
Format the results using accounting number format.
15
16
MENDOZA
17
PARKER
SLIPPI
18 NEWMAN
28
19
BURGESS
38 $
62 $
58 $
20
KNIGHT
21
HARRIS
22
FRAZIER
Recycle Bin
DESMUME
23
TATE
24
LONG
40
25
RAMIREZ
26
WELCH
27
28
29
30
Instructions
Mortgage calculation
Retirement 1
Retirement 2
+
JAdd-ins loaded successfully
囲
90%
Minceraft
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education