Question

In: Finance

A local furniture store is advertising a deal in which you buy a $4,700 living room...

A local furniture store is advertising a deal in which you buy a $4,700 living room set with three years before you need to make any payments (no interest cost is incurred).

How much money would you have to deposit now in a savings account earning 6 percent APR, compounded monthly, to pay the $4,700 bill in three years?

How much would you have to deposit in the savings account each month to be able to pay the bill?

Solutions

Expert Solution

Payment to be made after 3 years = 4700, APR = 6%

Monthly rate = APR / No of months in a year = 6% / 12 = 0.50%

Period = 3 years = 3 x 12 months = 36 months

Calculating Amount to deposit now in savings account

To find the money to deposit in savings bank account now, we will make use of pv function in excel

Formula to be used in excel: =pv(rate,nper,pmt,-fv)

Using pv fuction in excel, we get amount to be deposited now = $3927.53

Calculating amount to deposited in savings account each month

To find the amount to be deposited per month (at the end of the month), we will use pmt function in excel

Formula to be used in excel: =pmt(rate,nper,pv,-fv)

Using pmt function in excel, we get amount to be deposited per month =119.48


Related Solutions

A local furniture store is advertising a deal in which you buy a $3,700 dining room...
A local furniture store is advertising a deal in which you buy a $3,700 dining room set and do not need to pay for two years (no interest cost is incurred). How much money would you have to deposit now in a savings account earning 4 percent APR, compounded monthly, to pay the $3,700 bill in two years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Present Value = ? How much would you...
You wish to buy a $10,000 dining room set. The furniture store offers you a three-year...
You wish to buy a $10,000 dining room set. The furniture store offers you a three-year loan with an 11 percent APR. What are the monthly payments? (Round your answer to two decimal places.)
You wish to buy a $10,100 dining room set. The furniture store offers you a 2-year...
You wish to buy a $10,100 dining room set. The furniture store offers you a 2-year loan with an APR of 9 percent. What are the monthly payments? Payment ___ per month? How would the payment differ if you paid interest only? payment ___ per month
Mike went with his girlfriend to Bill's Furniture Store to purchase a living room set. When...
Mike went with his girlfriend to Bill's Furniture Store to purchase a living room set. When he found one that he liked, he told the salesperson (Jim ) that he required time to check his finances to make the purchase. Jim advised that "these units are going fast” but he would hold the “Royal Prince” living room set for him for ten days at a cost of $2,500 and he wrote the name of the unit, the cost and time...
Towncenter Furniture specializes in modern living room and dining room furniture. Merchandise sales are subject to...
Towncenter Furniture specializes in modern living room and dining room furniture. Merchandise sales are subject to an 8 percent sales tax. The firm’s credit sales and sales returns and allowances for February 2019 are reflected below, along with the general ledger accounts used to record these transactions. The balances shown are for the beginning of the month. DATE TRANSACTIONS Feb 1 Sold a living room sofa to Sun Yoo; issued Sales Slip 1615 for $4,790 plus sales tax of $383.20....
9) Rohan used a fixed installment loan from his bank to buy new living room furniture....
9) Rohan used a fixed installment loan from his bank to buy new living room furniture. He borrowed $9250 and has 48 monthly payments of $230.19 each. a. Find the APR of the loan. b. Instead of making his 18th payment, Rohan decides to pay the remaining balance on the loan. How much interest will Rohan save?
CRIMINAL LAW What if you put your living room furniture on the front lawn while you...
CRIMINAL LAW What if you put your living room furniture on the front lawn while you are having your carpets shampooed. The carpet is not dry by nightfall and you leave the furniture outside overnight. That night someone pulls in front of your house and puts the furniture in his truck and leaves. You make a police report. The furniture is later found by the police and the men who took the furniture claim they thought it was abandoned. Was...
5. Jamestown Furniture Co. is a small, but fast-growing manufacturer of living room furniture. Its two...
5. Jamestown Furniture Co. is a small, but fast-growing manufacturer of living room furniture. Its two principal products are end tables and sofas. There are five processes in the manufacturing at Jamestown: Cutting the lumber, cutting the fabric, sanding, staining, and assembly. Jamestown has one employee working in fabric cutting and one employee working in staining. These are relatively skilled workers and could be replaced only with some difficulty. The cutting and sanding operations are performed by two workers each,...
1. Suppose you want to buy some new furniture for your family room. You currently have...
1. Suppose you want to buy some new furniture for your family room. You currently have $500 and the furniture you want costs $589. If you can earn 5%, how many years will you have to wait if you don’t add any additional money? Round your answer to two decimals. 2. How much would you need to invest at the end of each year if you need $40,000 in 9 years and you can earn 6% interest? Round your answer...
You are the accountant for the Best Outdoor Living company which manufactures various outdoor furniture. The...
You are the accountant for the Best Outdoor Living company which manufactures various outdoor furniture. The furniture is sold by specialty stores and through internet outlets. You are responsible for reviewing costs and creating standards costs based on the information you have reviewed. One of your former colleagues has recently started a company to collect and sell data on industry benchmarks. You are offered the chance to receive benchmarks from other outdoor furniture companies for free if you will provide...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT