Construct a spreadsheet that estimates what the maximum social security payment will be in 40 years based on the following criteria: Retiring at age 70 (current maximum monthly Benefit is $4,555) The average Cost-Of-Living-Adjustment (COLA) of 3% Please build a spreadsheet like the one used in last weeks module that shows the year (working backwards from age 70 in forty years (ie your hypothetical is of a 30 year old) Using that spreadsheet, tell me how much that payment would be in todays dollars assuming a 2.5% inflationary factor

Construct a spreadsheet that estimates what the maximum social security payment will be in 40 years based on the following criteria: Retiring at age 70 (current maximum monthly Benefit is $4,555) The average Cost-Of-Living-Adjustment (COLA) of 3% Please build a spreadsheet like the one used in last weeks module that shows the year (working backwards from age 70 in forty years (ie your hypothetical is of a 30 year old) Using that spreadsheet, tell me how much that payment would be in todays dollars assuming a 2.5% inflationary factor

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

C++ only. Do not copy. Correct code will upvoted else downvote. Monocarp is playing a PC game. Presently he needs to finish the principal level of this game. A level is a rectangular framework of 2 lines and n sections. Monocarp controls a character, what begins in cell (1,1) — at the convergence of the 1-st line and the 1-st segment. Monocarp's character can move starting with one cell then onto the next in one stage if the cells are nearby by side or potentially corner. Officially, it is feasible to move from cell (x1,y1) to cell (x2,y2) in one stage if |x1−x2|≤1 and |y1−y2|≤1. Clearly, it is denied to go external the matrix. There are traps in certain cells. In case Monocarp's character winds up in such a cell, he bites the dust, and the game closures. To finish a level, Monocarp's character should arrive at cell (2,n) — at the crossing point of line 2 and section n. Assist Monocarp with deciding whether it is feasible to finish the level. Input The principal…
A teacher creates a spreadsheet to process a Mid Semester Examination. Column A holds the names of the students. Column B holds the data of the student if each student has passed or failed. The data in column B is either ‘pass’ or ‘fail’. The data starts at row 2 and ends at row 25. Describe how a standard built-in function in a spreadsheet could be used to calculate the number of students that have passed. The answer should be placed at the end of the data in column B.
(ms excel In Moray, employees have Wednesdays and Thursdays off, and the following holidays: January 1, February 12, April 5, May 4, July 21, October 10-12, December 24-26. Design a spreadsheet in which the user can enter start and end dates, and the worksheet returns the total number of working days? Your spreadsheet should work for end dates entered up to and including December 31, 2030. Use formulas to generate the dates of the holidays. The result should be blank if no dates are entered.
Complete the following in Java 1. Users should be able to use to populate the following arrays: Array Contents Developer Contains the names of all the developers assigned to tasks Task Names Contains the names of all the created tasks Task ID Contains the generated taskID’s for all tasks Task Duration Contains the Duration of all tasks Task Status Contains the Status of all tasks 2. Users should be able to use these arrays to: a. Display the Developer, Task Names and Task Duration for all tasks with the status of done.b. Display the Developer and Duration of the class with the longest duration.c. Search for a task with a Task Name and display the Task Name, Developer and Task Status.d. Search for all tasks assigned to a developer and display the Task Name and Task Status.e. Delete a task using the Task Name.f. Display a report that lists the full details of all captured tasks. 3. Use the following test Data for your unit tests and to populate your arrays:Test Data…
Q1: Research Groups In response to popular demand, Dan’s established two research groups A and B composed of his n graduate students. Each of these students is a member of exactly one of the two groups at any given time. The students are numbered from 1 to n in some arbitrary order. To measure the success of his research groups, Dan assigns a citation score to each of them. Initially, both groups have citation score 0. Throughout the semester, events of the following two types happen: Student x publishes a paper in which they cite student y’s work (youcan assume all of the students have been around long enough to have prior research that can be cited). As a result, If x and y are in the same group, their group’s citation score increases by 1. If x and y are in different groups, y’s group’s citation score increases by 5. Dan changes student x’s group (from A to B or from B to A) to have them work on different projects. To assess the overall success of the research groups, Dan…
Simple Student Management System Build the following app using Python Tkinter library. Using this app, user can • add student information • view all students • search student(s) by name • remove student by id Add • First name, last name, date of birth cannot be blank while adding a specific student information. • However major can be blank, which gets set to "Undefined" if left out blank. • Student Id is automatically generated by the program (ex: 1001, 1002, 1003, 1004 ….) If the user keeps a mandatory field blank (ex: First name) and presses "Add Student" button, it displays the following message box: first name is required If the user successfully enters all the necessary information and presses the "Add Student" button, it displays the following confirmation message box: student added View All When the user presses the "View All" button, it displays all the student’s information (Id, First name, Last name, Date of birth, and Major) in a nice formatted way. Example below: • Must…
3. Rewrite the above description using the structured approach described in this chapter.Resolve the identified ambiguities in an appropriate way. An automated ticket-issuing system sells rail tickets. Users select their destination andinput a credit card and a personal identification number. The rail ticket is issued and themcredit card account charged. When the user presses the start button, a menu display ofpotential destinations are activated, along with a message to the user to select a destination.Once a destination has been selected, users are requested to input their credit card. Itsvalidity is checked and the user is then requested to input a personal identifier. When thecredit transaction has been validated; the ticket is issued.
II. Application Q1. Given below is an example of e-commerce website. Analyze any one e-commerce website and write various test cases for it. Write any two test cases based on it and give at least three activities of each type of cases.
You work for an loan analytics organization have been tasked with writing a program that simulates an analysis of loan applications. Code a modular program that uses parallel arrays to store loan application credit scores (values generated between 300 and 900), score ratings (poor, fair, good, very good, or exceptional based on credit score) and loan status (approved or declined applications based on credit score). The program must do the following: The program must first ask the user for the number of loan applications that will be in the simulation. This must be done by calling the getNumLoanApplications() function (definition below). After the input of the number of accounts, the program must use loops and random numbers to generate the credit score, score rating, and application result for each loan application in parallel arrays. These arrays must not be declared globally (major error). The following arrays must be declared and populated: creditScores[] - an array of type int…
TopText Publishing is a textbook publishing company with a headquarters location, a warehouse, and three sales offices that each have a sales manager and sales reps. TopText sells to schools, colleges, and individual customers. Many authors write more than one book for TopText, and more than one author writes some books. TopText maintains an active list of more than 100 books, each identified by a universal code called an ISBN. You have been asked to draw an ERD for the TopText information system and to include cardinality notation in your diagram.
Using C language in visual studio,arrays,pointers,functions,and if possible using a switch case. Build an application for a car rental company. It should offer the following features: 1-• Maintain a customer database in a file: o Register / add new customers. Customer information should include ▪ Customer ID number ▪ Name ▪ Phone number o Search customer database by: ▪ Customer ID number ▪ Name ▪ Phone number And print out the matching records And an option to go back 2-• Maintain a database in a file: o Add a new vehicle to the fleet. Vehicle information should include ▪ Model year ▪ Make ▪ Model name ▪ License plate number ▪ Customer number who is currently renting vehicle o Delete a vehicle from the fleet o Rent a vehicle to a registered customer o Receive rented vehicle back from customer o Search vehicle database by any field: ▪ Model year + Make + Model name ▪ License plate number ▪ Customer number who is currently renting vehicle And print out all matching records And an…
In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write an algorithm in pseudocode, a flowchart and NS diagrams that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.