As a result of a slowdown in operations, Mercantile Stores is offering to employees who have been terminated a severance package of $170,000 cash, another $170,000 to be paid in one year, and an annuity of $37,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 $170,000 face value Present value of $37,000 annuity Total Excel values based on i= 9 % 9 % n= 1 20 $ 170,000 155,963

As a result of a slowdown in operations, Mercantile Stores is offering to employees who have been terminated a severance package of $170,000 cash, another $170,000 to be paid in one year, and an annuity of $37,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 $170,000 face value Present value of $37,000 annuity Total Excel values based on i= 9 % 9 % n= 1 20 $ 170,000 155,963

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

milgard barbers decides to lease another barbershop for a 5- year period. the has a cash price of $240,000. milgard borrowed money to purchase the shop, it would have had to pay 20% interest read the (use the present value and future value tables, a financial calculator, or a spreadsheet for your calculations. if using present and future value tables or the formula method, use factor amounts rounded to five decimal places. round your final answer to the nearest cent. (click the icon to view the future value of ) (click the icon to view the future value of an ordinary annuity table .) (click the icon to view the future value of an annuity due to table) a. what are the required payments if the lease agreement requires annual payments beginning one year from today? the required payments are $ B. what are the required payments if the lease agreement requires semiannual payments beginning six months from the required payments are. C. what are the required payments if the lease agreement…
Crab State Bank has offered you a $1,500,000 5-year loan at an interest rate of 9.25 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.25%) Principal Reduction Balance Remaining 0 - - - $1,500,000 1 $ $ $ 2 3 4 5
A company buys a machine for $18,000, which it agrees to pay for in five equal annual payments, beginning one year after the date of purchase, at an annual interest rate of 7%. Immediately after the second payment, the terms of the agreement are changed to allow the balance due to be paid off in a single payment the next year. What is the final single payment? Solution: 1. Draw the CFD by yourself; 2. First, calculate annual payment amount for the first 2 years: O A= + 7%, • )=18000x =$ o The final payment is the • worth of the : unpaid payments. 3. Second, Calculate the single payment amount due at the end of the 3rd year: F=S
An accounting firm agrees to purchase a computer for $180,000 (cash on delivery) and the delivery date is in 270 days. How much do the owners need to deposit in an account paying 0.85% compounded quarterly so that they will have $180,000 in 270 days? (a) State the type. sinking fund amortization present value future value ordinary annuity (b) Answer the question. (Round your answer to the nearest cent.) $
Suppose that on January 1 you have a balance of $6,000 on the following credit cards, which you want to pay off in the given amount of time. Assume that you make no additional charges to the card after January 1. The credit card APR is 24%, and you want to pay off the balance in 1 year. Round to the nearest cent The credit card APR is 25%, and you want to pay off the balance in 2 years. $ Round to the nearest cent The credit card APR is 26%, and you want to pay off the balance in 3 years. Round to the nearest cent
A small business owner visits his bank to ask for a loan. The owner states that he can repay a loan at $3,100 per month for the next three years and then $2,100 per month for two years after that. If the bank is charging customers 10.00 percent APR, how much would it be willing to lend the business owner? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Present value
Pool-N-Patio World needs to borrow $50,000 to increase its inventory for the upcoming summer season. The owner is confident that he will sell most, if not all, of the new inventory during the summer, so he wishes to borrow the money for only four months. His bank has offered him a simple interest amortized loan at 73% interest. (Round your answers to the nearest 4 cent.) (a) Find the size of the monthly bank payment. Interest Portion Total Payment Balance Due (b) Prepare an amortization schedule for all four months of the loan. Principal Portion A A A Payment Number 0 1 2 3 4 A $ A LA +A $ A A A A A $ +A $ +A
Wontaby Ltd. is extending its credit terms from 30 to 45 days. Sales are expected to increase from $4.90 million to $6.00 million as a result. Wontaby finances short-term assets at the bank at a cost of 10 percent annually. Calculate the additional annual financing cost of this change in credit terms. (Use 365 days in a year. Do not round intermediate calculations. Round the final answer to the nearest whole dollar. Enter answer in whole dollar not in million.) Annual financing cost $
Pls help correct thanks . Prepare an amortization schedule for a three-year loan of $102,000. The interest rate is 11 percent per year, and the loan agreement calls for a principal reduction of $34,000 every year. How much total interest is paid over the life of the loan?.
A local bank advertises the following deal: "Pay us $100 at the end of each year for 10 years and then we will pay you (or your beneficiaries) $100 at the end of each year forever." a. Calculate the present value of your payments to the bank if the interest rate is 6%. Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Present value b. What is the present value of a $100 perpetuity deferred for 10 years if the interest rate is 6%? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Present value c. Is this a good deal? Yes No
An accounting firm agrees to purchase a computer for $130,000 (cash on delivery) and the delivery date is in 270 days. How much do the owners need to deposit in an account paying 0.55%compounded quarterly so that they will have $130,000 in 270 days? (a) State the type. sinking fundamortization ordinary annuitypresent valuefuture value (b) Answer the question. (Round your answer to the nearest cent.)