13_PVA_ComputerLab_Worksheet-1.pdf - Bus 14A Lab Worksheet PVA Wurst MATH OF FINANCE LAB WORKSHEET Present Value Annuity Withdrawal 1 Click on the Home

13_PVA_ComputerLab_Worksheet-1.pdf - Bus 14A Lab Worksheet...

This preview shows page 1 out of 1 page.

Bus 14A Lab Worksheet MATH OF FINANCE LAB WORKSHEET PVA Wurst Present Value Annuity Withdrawal: 1. Click on the Home tab. 2. Click in the cell (ex. B12) that you want your answer to appear. 3. Click fx (Function Wizard) in the toolbar directly above the Column Letters in the worksheet. 4. In the Insert Function window, type Financial in the Search textbox and press GO. 5. Scroll and select PMT . 6. Click OK . 7. Enter periodic Rate . 8. Enter the Nper (number of periods). 9. Enter Pv (present value). 10. Click OK to find your results. Problems: 1. Find the monthly payment for an equipment mortgage of $54,000 for 3 years at 8%. 2. Find the quarterly payment for an equipment mortgage of $54,000 for 3 years at 12%. 3. Find the semi-annual payment for an equipment mortgage of $54,000 for 3 years at 7%. 4. Find the monthly payment for an equipment mortgage of $54,000 for 3 years at 18%.
Image of page 1

Unformatted text preview: 5. You have deposited $50,000 into an account earning 6% compounded semi-annually. For the first 5 years of your retirement, you want to withdrawal equal amounts every six months. How much is the withdrawal? 6. You have deposited $50,000 into an account earning 6% compounded annually. For the first 5 years of your retirement, you want to withdrawal equal amounts every twelve months. How much is the withdrawal? 7. You have deposited $50,000 into an account earning 6% compounded quarterly. For the first 5 years of your retirement, you want to withdrawal equal amounts every three months. How much is the withdrawal? 8. You have deposited $50,000 into an account earning 6% compounded monthly. For the first 5 years of your retirement, you want to withdrawal equal amounts every month. How much is the withdrawal?...
View Full Document

  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes