Question: The spreadsheet calculates a yearly pension. Users enter the pension percentage as a percent in cell B1, the number of years worked in cell B2,

The spreadsheet calculates a yearly pension. Users enter the pension percentage as a percent in cell B1, the number of years worked in cell B2, and the last four working years' salaries in cells B3-B6. That 4-year average salary is calculated and displayed in cell B7. The yearly pension amount is calculated and displayed in cell B8.
a. Write the spreadsheet formula for cell B7.
b. Write the spreadsheet formula for cell B8.

Pension percentage 2 Years worked 3 Year 1 salary 4 Year 2 salary 5 Year 3 salary 6 Year 4 salary 7 Average salary 8 Yearly pension

Step by Step Solution

★★★★★

3.46 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The salaries are in cells B3 B4 B5 B6 The form... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

790-L-A-L-S (1820).docx

120 KBs Word File

Students Have Also Explored These Related Linear Algebra Questions!

The original price of a car is entered into spreadsheet cell A1 and the length of time it takes to totally depreciate is entered into cell B1. a. Write the spreadsheet formula that calculates the...

As part of their employee benefits, all workers at Middletown Electronics receive a pension that is calculated by multiplying the number of years worked times 1.65% of the average of their three...

Peterson Products calculates its pension benefits as follows: Years of service 1.98% multiplier Average of last two annual salaries What is Mary's monthly pension benefit if she worked for Peterson...

Project Description: You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail store that has locations in only ten states. The company is considering branching into...

Any help would be great! B-Trendz, Inc. 1 2018 Quarterly Sales 2 Product Online Product Line Ranking Sales at a Glance Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Product Line Rank 3 4...

AutoSave OFF A A F Y C ... meEagle02_grader_hw_B-Trendz Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Share Comments Calibri (Body) AA Wrap Text v General di- V v Paste BIUV...

I need a step-by-step guide with screenshots and formulas Project Description: You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail store that has locations in...

You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail store that has locations in only ten states. The company is considering branching into the online retail...

Step Points Instructions Possible 1 Start Excel. Open the file named e02_grader_hw_B-Trendz.x/sx. Save the file with the name 0 202_grader_hw_B-Trendz_LastFirst, replacing Lastfirst with your last...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

The is true about profitability drivers and industry demand determinants: Group of answer choices The economic recession had no impact. World pricing of coffee has little impact Per capita tea...

Portmore Development Limited currently has two construction contracts. The contracts involve the construction of a Health Clinic at Cumberland, and a new hotel in Hellshire. Management is unaware...

A bank rule is used if you receive a new transaction that you've not received before. Select one: True False

The model: CEt = 1 + 2YDt + 3CEt1 + vt (10.41) (where CE = aggregate consumer expenditure and YD = personal disposable income) was estimated by simple OLS using data for the UK economy. The results...

For the polynomial P(x) = x4 - 6x3 + x - 2 and the divisor d(x) = x - 1, use long division to find the quotient Q(x) and the remainder R(x) when P(x) is divided by d(x). Express P(x) in the form d(x)...

Use synthetic division to find the quotient and the remainder. a. (3x4 - x3 + 2x2 - 6x + 6) ( (x - 2) b. (x5 - 5) ( (x + 1)

Use synthetic division to find the function values. 1. g(x) = x3 - 9x2 + 4x - 10 ; find g(-5) 2. f (x) = 20x2 - 40x ; find f () 3. f(x) = 5x4 + x3 - x; find f(- (2).

The Snedecker Corporation is considering a change in its cash-only policy. The new terms would be net one period. The required return is 1.6 percent per period. Based on the following information,...

QUESTION 6 If the simple CAPM is valid and all portfolios are priced correctly, which of the situations below is possible? Consider each situation independently, and assume the risk-free rate is 5%....

what is a compensating control in security controls?