- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

CASE STUDY DONE USING EXCEL MUST SHOW CALCULATIONS AND SOLUTION

Instructions Please complete the following: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. Remember to show all calculations. You must show your calculations. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer—without my needing to do a lot of "investigative work." CASE STUDY Sunrise Industries wishes to accumulate funds to provide a retirement annuity for its vice president of research, Jill Moran. Ms. Moran, by contract, will retire at the end of exactly 12 years. Upon retirement, she is entitled to receive an annual end-of-year payment of $42,000 for exactly 20 years. If she dies prior to the end of the 20-year period, the annual payments will pass to her heirs. During the 12-year “accumulation period,” Sunrise wishes to fund the annuity by making equal, annual, end-of-year deposits into an account earning 9% interest. Once the 20-year “distribution period” begins, Sunrise plans to move the accumulated monies to an account earning a guaranteed 12% per year. At the end of the distribution period, the account balance will equal zero. Note that the first deposit will be made at the end of year 1 and that first distribution payment will be received at the end of year 13. Case Study Questions: 1. How large a sum must Sunrise accumulate by the end of year 12 to provide the 20-year, $42,000 annuity? 2. How large must Sunrise’s equal, annual, end-of-year deposits into the account be over the 12-year accumulation period to fund fully Ms. Moran’s retirement annuity? 3. How much would Sunrise have to deposit annually during the accumulation period if it could earn 10% rather than 9% during the accumulation period? 4. How much would Sunrise have to deposit annually during the accumulation period if Ms. Moran’s retirement annuity were a perpetuity and all other terms were the same as initially described? Instructions Please complete the following: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. Remember to show all calculations. You must show your calculations. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer—without my needing to do a lot of "investigative work." CASE STUDY Sunrise Industries wishes to accumulate funds to provide a retirement annuity for its vice president of research, Jill Moran. Ms. Moran, by contract, will retire at the end of exactly 12 years. Upon retirement, she is entitled to receive an annual end-of-year payment of $42,000 for exactly 20 years. If she dies prior to the end of the 20-year period, the annual payments will pass to her heirs. During the 12-year “accumulation period,” Sunrise wishes to fund the annuity by making equal, annual, end-of-year deposits into an account earning 9% interest. Once the 20-year “distribution period” begins, Sunrise plans to move the accumulated monies to an account earning a guaranteed 12% per year. At the end of the distribution period, the account balance will equal zero. Note that the first deposit will be made at the end of year 1 and that first distribution payment will be received at the end of year 13. Case Study Questions: 1. How large a sum must Sunrise accumulate by the end of year 12 to provide the 20-year, $42,000 annuity? 2. How large must Sunrise’s equal, annual, end-of-year deposits into the account be over the 12-year accumulation period to fund fully Ms. Moran’s retirement annuity? 3. How much would Sunrise have to deposit annually during the accumulation period if it could earn 10% rather than 9% during the accumulation period? 4. How much would Sunrise have to deposit annually during the accumulation period if Ms. Moran’s retirement annuity were a perpetuity and all other terms were the same as initially described?

Instructions Please complete the following: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. Remember to show all calculations. You must show your calculations. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer—without my needing to do a lot of "investigative work." CASE STUDY Sunrise Industries wishes to accumulate funds to provide a retirement annuity for its vice president of research, Jill Moran. Ms. Moran, by contract, will retire at the end of exactly 12 years. Upon retirement, she is entitled to receive an annual end-of-year payment of $42,000 for exactly 20 years. If she dies prior to the end of the 20-year period, the annual payments will pass to her heirs. During the 12-year “accumulation period,” Sunrise wishes to fund the annuity by making equal, annual, end-of-year deposits into an account earning 9% interest. Once the 20-year “distribution period” begins, Sunrise plans to move the accumulated monies to an account earning a guaranteed 12% per year. At the end of the distribution period, the account balance will equal zero. Note that the first deposit will be made at the end of year 1 and that first distribution payment will be received at the end of year 13. Case Study Questions: 1. How large a sum must Sunrise accumulate by the end of year 12 to provide the 20-year, $42,000 annuity? 2. How large must Sunrise’s equal, annual, end-of-year deposits into the account be over the 12-year accumulation period to fund fully Ms. Moran’s retirement annuity? 3. How much would Sunrise have to deposit annually during the accumulation period if it could earn 10% rather than 9% during the accumulation period? 4. How much would Sunrise have to deposit annually during the accumulation period if Ms. Moran’s retirement annuity were a perpetuity and all other terms were the same as initially described? Instructions Please complete the following: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. Remember to show all calculations. You must show your calculations. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer—without my needing to do a lot of "investigative work." CASE STUDY Sunrise Industries wishes to accumulate funds to provide a retirement annuity for its vice president of research, Jill Moran. Ms. Moran, by contract, will retire at the end of exactly 12 years. Upon retirement, she is entitled to receive an annual end-of-year payment of $42,000 for exactly 20 years. If she dies prior to the end of the 20-year period, the annual payments will pass to her heirs. During the 12-year “accumulation period,” Sunrise wishes to fund the annuity by making equal, annual, end-of-year deposits into an account earning 9% interest. Once the 20-year “distribution period” begins, Sunrise plans to move the accumulated monies to an account earning a guaranteed 12% per year. At the end of the distribution period, the account balance will equal zero. Note that the first deposit will be made at the end of year 1 and that first distribution payment will be received at the end of year 13. Case Study Questions: 1. How large a sum must Sunrise accumulate by the end of year 12 to provide the 20-year, $42,000 annuity? 2. How large must Sunrise’s equal, annual, end-of-year deposits into the account be over the 12-year accumulation period to fund fully Ms. Moran’s retirement annuity? 3. How much would Sunrise have to deposit annually during the accumulation period if it could earn 10% rather than 9% during the accumulation period? 4. How much would Sunrise have to deposit annually during the accumulation period if Ms. Moran’s retirement annuity were a perpetuity and all other terms were the same as initially described?

Answered 1 days AfterJan 30, 2024

Q1: How large a sum must Sunrise accumulate by the end of year 12 to provide the 20-year, $

Particular Amount

Annual Payment (PMT) $42,000.00

No. of Year (NPER) 20

Rate of Interst (RATE) 12%

Amount to be accumulate by end of Year 12 $313,716.63 Answer

Q2. How large must Sunrise’s equal, annual, end-of-year deposits into the account be over the 12-year accumulation period...

SOLUTION.PDF## Answer To This Question Is Available To Download

- InstructionsPlease complete the following:· Problem P17-4· Problem P17-9· Problem P18-1· Problem P18-15· Problem P19-1Carry all calculations to TWO decimal places to reduce rounding...SolvedFeb 25, 2024
- InstructionsPlease complete the following:· Problem P15-1· Problem P15-4· Problem P15-13· Problem P16-2· Case - Kanton CompanyCarry all calculations to TWO decimal places to reduce...SolvedFeb 15, 2024
- Instructions Please complete the following:· Problem P13-1· Problem P13-15· Problem P13-21· Problem P14-8· Problem P14-14Carry all calculations to TWO decimal places to reduce rounding...SolvedFeb 12, 2024
- InstructionsPlease complete the following · Problem P10-24· Problem P10-28· Problem P11-11· Problem P11-16· Problem P12-12· Problem P12-20· Problem P12-28Carry all calculations to...SolvedFeb 07, 2024
- InstructionsPlease complete the following:· Problem P8-18· Problem P8-28· Problem P9-5· Problem P9-15· Integrative Case 4 - Enviro Plastics CompanyGeneral Instructions for...SolvedFeb 05, 2024
- InstructionsPlease complete the following:· Problem P6-9· Problem P6-17· Problem P6-31· Problem P7-20· Problem P7-23Carry all calculations to TWO decimal places to reduce rounding error,...SolvedFeb 02, 2024
- CASE STUDY ON EXCEL MUST SHOW WORK AND CALCULATIONSJan 30, 2024
- Assignment Notes: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems.Remember to show all calculations.General Instructions for Written...SolvedJan 26, 2024
- ALL WORK MUST BE DONE ON EXCEL SPREEDSHEETS PLEASE USE SEPERATE SHEET FOR EACH PROBLEM P1-4Marginal cost-benefit analysis and the goal of the firm Monsanto Corporation is considering the...SolvedJan 20, 2024
- The initialperiod 4dialoguepost has two parts. To complete the first part of your post, read the attached Upstate NY Real Estate .pdffileandindicate your leasing decision. Cite specific ratios and...SolvedApr 27, 2023

Copy and Paste Your Assignment Here

Copyright © 2024. All rights reserved.