As a result of a slowdown in operations, Mercantile Stores is offering to employees who have been terminated a severance package of $210,000 cash, another $210,000 to be paid in one year, and an annuity of $41,000 to be paid each year for 20 years. Use Excel to compute the present value of the complete package, assuming an interest rate of 9 percent. (Round your final answers to the nearest whole dollar amount.) Cash Payment Present value of $210,000 face value Present value of $41,000 annuity Total Excel values based on no % % 1 9 $ 210,000 192.661

As a result of a slowdown in operations, Mercantile Stores is offering to employees who have been terminated a severance package of $210,000 cash, another $210,000 to be paid in one year, and an annuity of $41,000 to be paid each year for 20 years. Use Excel to compute the present value of the complete package, assuming an interest rate of 9 percent. (Round your final answers to the nearest whole dollar amount.) Cash Payment Present value of $210,000 face value Present value of $41,000 annuity Total Excel values based on no % % 1 9 $ 210,000 192.661

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 3P: Del Hawley, owner of Hawleys Hardware, is negotiating with First City Bank for a 1-year loan of...

See similar textbooks

Similar questions

PLEASE HELP!
A person buys a piece of lot for P110,000 down payment and 10 deferred semi-annual payments of P 8,000 each, starting two years from now. What is the present value of the investment if the rate of interest is 12% compounded semi-annually? (1) Effective Interest C = Blank 1 K = Blank 2 Thus, ieff = Blank 3 (2) Final Answer = PHP Blank 4 NOTE: Do not round in between solutions. Final answer round to two decimal places
help solve
Live Forever Insurance Company is selling a perpetual annuity contract that pays $2,700 monthly. The contract currently sells for $329,000. a. What is the monthly return on this investment vehicle? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. What is the APR? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. c. What is the effective annual return? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. a. Monthly return b. Annual percentage rate c. Effective annual return % % %
ABC Marketing sold an item worth 200,000 for 250,000. As agreed 20,000 will the down payment while the balance will be evidence buy a noninterest bearing note with an implied interest rate of 9% to be paid annually within 5 years. What is the amortization schedule for the payments?
Please answer in text form without image
Hi, can you please help me solve this problem? I need one amortization table per each problem, 3 of them at all. List price, $ 350,000 Payment alternatives 1. Down payment of 20% and the rest paid monthly for 5 years. The fixed interest rate of the financier is 15.99% annually / monthly. Commission for opening credit equal to 3% (initial single payment on the approved amount).2. Down payment of 20% and the rest to be paid in 36 months with a fixed interest rate of 15.99% per year / per year. Commission for opening credit equal to 3% (initial single payment on the approved amount).3. Pay a car in cash with a discount of 5% invoice value. If Juan decides this option, he knows that he would have to apply for a personal loan at the bank where he has his payroll, he would offer to supplement the amount of the value of the car. The rate that would be charged for the personal loan is 23.75% per year / biweekly for a 72-month term, with fixed biweekly payments. THANK YOU SO MUCH!
Don Draper has signed a contract that will pay him $50,000 at the end of each year for the next 8 years, plus an additional $150,000 at the end of year 8. If 7 percent is the appropriate discount rate, what is the present value of this contract? Question content area bottom Part 1 The present value of the contract is $ enter your response here . (Round to the nearest cent.)
Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.75 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. Do not round intermediate calculations. End of Year Payment Interest (9.75%) Principal Reduction Balance Remaining 0 - - - $500,000 1 $ $ $ 2 3 4 5
Your answer is incorrect. Sheridan Company is considering investing in an annuity contract that will return $33,500 annually at the end of each year for 15 years. Click here to view the factor table. What amount should Sheridan Company pay for this investment if it earns an 10% return? (For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round answer to 2 decimal places, e.g. 25.25.) Sheridan Company should pay $ eTextbook and Media Save for Later SUPP Attempts: 2 of 3 used Submit Answer
Your company is considering purchasing an expensive plece of equipment. The manufacturer of the equipment offers a payment plan to pay $100,000 annually for 4 years. Assuming no other cash flow, the first payment is due at the end of the first year, and an interest rate of 6%, the minimum Present amount of money you will need is most nearly O $370,000 O $380.000 O 390.000 O 5400,000 O 5410.000 O S420.000
Find the valuo of a retiroment savings account paying an APR of 5.8% aftor 30 yoars (contributions made at the end of each year, including the last year) when the annual contribution is shown (a) $1300 (b) S740 (c) $1900 (a) When the annual contribution is $1300, the value of a retirement savings account paying an APR of 5 8% after 30 years is $ (Do not round until the final answer Then round to the nearest cent as needed) (b) When the annual contribution is $740, the value of a retirement savings account paying an APR of 5 8% after 30 yoars is $ (Do not round until the final answer Then round to the nearest cent as needed) (e) When the annual contribution is $1900, the value of a retroment savings account paying an APR of 5 8% after 30 years is $ (Do not round until the final answer. Then round to the nearest cent as noeded)