Question

Suzanne had a summer job working in the business office of Blast-It TV and Stereo, a local chain of home electronics stores. When Michael Jacobssen, the owner of the chain, heard she had completed one year of business courses, he asked Suzanne to calculate the profitability of two new large-screen televisions. He plans to offer a special payment plan for the two new models to attract customers to his stores. He wants to heavily promote the more profitable TV.

When Michael gave Suzanne the information about the two TVs, he told her to ignore all taxes when making her calculations. The cost of television A to the company is $1950 and the cost of television B to the company is $2160, after all trade discounts have been applied. The company plans to sell television A for a $500 down payment and $230 per month for 12 months, beginning 1 month from the date of the purchase. The company plans to sell television B for a $100 down payment and $260 per month for 18 months, beginning 1 month from the date of purchase. The monthly payments for both TVs reflect an interest rate of 15.5% compounded monthly.

Michael wants Suzanne to calculate the profit of television A and television B as a percent of the TV’s cost to the company. To calculate profit, Michael deducts overhead (which he calculates as 15% of cost) and the cost of the item from the selling price of the item. When he sells items that are paid for at a later time, he calculates the selling price as the cash value of the item. (Remember that cash value equals the down payment plus the present value of the periodic payments.) Suzanne realized that she could calculate the profitability of each television by using her knowledge of ordinary annuities. She went to work on her assignment to provide Michael with the information he requested.

Questions:
a. What is the cash value of television A? Round your answer to the nearest dollar.
b. What is the cash value of television B? Round your answer to the nearest dollar.
c. Given Michael’s system of calculations, how much overhead should be assigned to television A?
d. How much overhead should be assigned to television B?
e. According to Michael’s system of calculations, what is the profit of television A as a percent of its cost?
f. What is the profit of television B as a percent of its cost?
g. Which TV should Suzanne recommend be more heavily promoted?
h. Three months later, due to Blast-It’s successful sales of television A and television B, the suppliers of each model gave the company new volume discounts. For television A, Blast-It received a discount of 9% off its current cost, and for television B one of 6%. The special payment plans for television A and television B will stay the same. Under these new conditions, which TV should Suzanne recommend be more heavily promoted?

Answer 1

		Present Value (PV) of Cash Flow:
		(Cash Flow)/((1+i)^N)
		i=Discount Rate=(15.5/12)%=	1.292%	0.01292
		N=Month of Cash Flow
	a.	TELEVISON A
	N	Month	0	1	2	3	4	5	6	7	8	9	10	11	12
	A	Cash Flow	$500	$230	$230	$230	$230	$230	$230	$230	$230	$230	$230	$230	$230	SUM
	B=A/(1.01292^N)	Present Value (PV) of Cash Flow:	$500	$227.07	$224.17	$221.31	$218.49	$215.70	$212.95	$210.24	$207.56	$204.91	$202.30	$199.72	$197.17	$3,042
		Cash Value of Television A	$3,042
	b.	TELEVISON B
	N	Month	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18
	A	Cash Flow	$100	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	SUM
	B=A/(1.01292^N)	Present Value (PV) of Cash Flow:	$100	$256.68	$253.41	$250.18	$246.99	$243.84	$240.73	$237.66	$234.63	$231.64	$228.68	$225.77	$222.89	$220.05	$217.24	$214.47	$211.73	$209.03	$206.37	$4,252
		Cash Value of Television B	$4,252
		Overhead =15% of Cost
	c	Overhead of Television A	$293	(1950*0.15)
	d	Overhead of Television B	$324.00	(2160*0.15)
	e	Profit of Television A	$799	(3042-1950-293)				.
		Profit as percent of cost	40.97%	(799/1950)*100%
	f	Profit of Television B	$1,768	(4252-2160-324)
		Profit as percent of cost	81.85%	1768/2160)*100%
	g	Television B should be heavily promoted
	(3042-1950-293) 40.97% (799/1950)*100% (4252-2160-324) 81.85% 1768/2160)*100 % $799 Profit of Television A e Profit as percent of cost $1,768 f Profit of Television B Profit as percent of cost Television B should be heavily promoted $1,775 (91% 1950) $2,030 (94%*2160) $266 (0.15*1775) $305 (0.15 2030) h New Cost of Television A New Cost of Television B New Overhead of Television A New Overhead of Television B $1,001 (3042-1775-266) 56.41% (1001/1775)*100% $1,917 (4252-2030-305) 94.41% (1917/2030)*100 % Profit of Television A Profit as percent of cost Profit of Television B Profit as percent of cost Television B should be heavily promoted C b0