KT Televisions, a US firm, has a Chinese subsidiary that manufactures and sells TVs in China.
a. Main input is priced in USD (USD110/unit)
b. All other costs are in RMB (Fixed cost=RMB4M, Variable cost= RMB460/unit).
c. Depreciation = RMB1.3M
d. S0 = RMB6.26/USD
e. Expects to sell 7,000 TVs this year at RMB2,000 each.
f. Tax rate=30%; assuming tax credits are available for immediate use if losses occur
You are required to show all your workings: a) What are the operating cash flows in RMB and dollars?
b) How many unit KT Televisions needs to sell to break-even in operating cash flows in dollars? (Hint: round your answer up to the nearest unit)
Ignore part (a) and part (b) for the following questions and assume that the normal sales are 8,000 Units for the rest of the questions. c) What are your operating cash flows in dollars now?
d) If the spot rate reduces to RMB4.6/USD, KT would like to pass all benefits to his client by reducing selling price. What would be the new selling price that would maintain his profit (operating cash flows in dollars) in Part (c) and would pass all benefits to his client at the same time?
Operating Cash Flow(RMB) | RMB | ||||
A | Number of units sold | 7000 | |||
B | Sales Price per unit | 2000 | |||
C=A*B | Total Sales Revenue | 14,000,000 | |||
D | Input Price per unit=110*6.26 | 688.60 | |||
E=A*D | Total Input cost | (4,820,200) | |||
F | Unit Variable Cost | 460 | |||
G=A*F | Total Variable Costs | (3,220,000) | |||
H | Fixed costs | (4,000,000) | |||
I | Depreciation | (1,300,000) | |||
J=C+E+G+H+I | Before tax operating income | 659,800 | |||
K=J*30% | Tax expenses | (197,940) | |||
L=J+K | After tax Operating Income | 461,860 | |||
M | Add:Depreciation (non cash expense) | 1,300,000 | |||
N=L+M | Operating Cash Flow | 1,761,860 | |||
Operating Cash Flow(Dollars) | Dollar | ||||
A | Number of units sold | 7000 | |||
B | Sales Price per unit | $319.49 | (2000/6.26) | ||
C=A*B | Total Sales Revenue | $2,236,422 | |||
D | Input Price per unit | $110.00 | |||
E=A*D | Total Input cost | -$770,000 | |||
F | Unit Variable Cost | $73.48 | (460/6.26) | ||
G=A*F | Total Variable Costs | -$514,377 | |||
H | Fixed costs | -$638,978 | (4million/6.26) | ||
I | Depreciation | -$207,668 | (1.3 million/6.26) | ||
J=C+E+G+H+I | Before tax operating income | $105,399 | |||
K=J*30% | Tax expenses | -$31,620 | |||
L=J+K | After tax Operating Income | $73,780 | |||
M | Add:Depreciation (non cash expense) | $207,668 | |||
N=L+M | Operating Cash Flow | $281,447 | |||
b) | Break Even units (Cash flow in dollars) | ||||
CM=B-D-F | Contribution Margin Per Unit | $136.01 | |||
FC=-H-I | Total Fixed Costs | $846,645 | |||
Break Even units =Fixed Costs/Unit Contribution margin | |||||
BEP=FC/CM | Accounting Break Even Point in units | 6225 | |||
Operating Cash Flow(Dollar) | Dollar | ||||
A | Number of units sold | 4044 | |||
B | Sales Price per unit | $319.49 | |||
C=A*B | Total Sales Revenue | $1,292,013 | |||
D | Input Price per unit | $110.00 | |||
E=A*D | Total Input cost | -$444,840 | |||
F | Unit Variable Cost | $73.48 | |||
G=A*F | Total Variable Costs | -$297,163 | |||
H | Fixed costs | -$638,978 | |||
I | Depreciation | -$207,668 | |||
J=C+E+G+H+I | Before tax operating income | -$296,636 | |||
K=J*30% | Tax expenses | $88,991 | |||
L=J+K | After tax Operating Income | -$207,645 | |||
M | Add:Depreciation (non cash expense) | $207,668 | |||
N=L+M | Operating Cash Flow | $23 | |||
Break even sales in units for operating cash flow | 4044 | ||||
c | Operating Cash Flow for sales of 8000 units | ||||
Operating Cash Flow(Dollar) | Dollar | ||||
A | Number of units sold | 8000 | |||
B | Sales Price per unit | $319.49 | |||
C=A*B | Total Sales Revenue | $2,555,911 | |||
D | Input Price per unit | $110.00 | |||
E=A*D | Total Input cost | -$880,000 | |||
F | Unit Variable Cost | $73.48 | |||
G=A*F | Total Variable Costs | -$587,859 | |||
H | Fixed costs | -$638,978 | |||
I | Depreciation | -$207,668 | |||
J=C+E+G+H+I | Before tax operating income | $241,406 | |||
K=J*30% | Tax expenses | -$72,422 | |||
L=J+K | After tax Operating Income | $168,984 | |||
M | Add:Depreciation (non cash expense) | $207,668 | |||
N=L+M | Operating Cash Flow | $376,652 | |||
d | If spot rate reduces to RMB 4.6/USD | ||||
Operating Cash Flow(Dollars) | Dollar | ||||
A | Number of units sold | 7000 | |||
B | Sales Price per unit | $434.78 | (2000/4.6) | ||
C=A*B | Total Sales Revenue | $3,043,478 | |||
D | Input Price per unit | $110.00 | |||
E=A*D | Total Input cost | -$770,000 | |||
F | Unit Variable Cost | $100.00 | (460/4.6) | ||
G=A*F | Total Variable Costs | -$700,000 | |||
H | Fixed costs | -$869,565 | (4million/4.6) | ||
I | Depreciation | -$282,609 | (1.3 million/4.6) | ||
J=C+E+G+H+I | Before tax operating income | $421,304 | |||
K=J*30% | Tax expenses | -$126,391 | |||
L=J+K | After tax Operating Income | $294,913 | |||
M | Add:Depreciation (non cash expense) | $282,609 | |||
N=L+M | Operating Cash Flow | $577,522 | |||
New Operating Cash Flow=$577,522 | |||||
Reduction in Sales Price to obtain Operating Cash Flow= | $281,447 | ||||
Operating Cash Flow(Dollars) | Dollar | ||||
A | Number of units sold | 7000 | |||
B | Sales Price per unit | $374.36 | (2000/4.6) | ||
C=A*B | Total Sales Revenue | $2,620,520 | |||
D | Input Price per unit | $110.00 | |||
E=A*D | Total Input cost | -$770,000 | |||
F | Unit Variable Cost | $100.00 | (460/4.6) | ||
G=A*F | Total Variable Costs | -$700,000 | |||
H | Fixed costs | -$869,565 | (4million/4.6) | ||
I | Depreciation | -$282,609 | (1.3 million/4.6) | ||
J=C+E+G+H+I | Before tax operating income | -$1,654 | |||
K=J*30% | Tax expenses | $496 | |||
L=J+K | After tax Operating Income | -$1,158 | |||
M | Add:Depreciation (non cash expense) | $282,609 | |||
N=L+M | Operating Cash Flow | $281,451 | |||
New Selling Price in RMB =374.36*4.6= | $1,722.06 | RMB | |||
Reduction in price =2000-1722.06 | $277.94 | RMB | |||
KT Televisions, a US firm, has a Chinese subsidiary that manufactures and sells TVs in China....
Dent Enterprises (DE), a US-based medical research firm, has recently identified an island off the northeastern coast of Canada that it believes contains a large population of special spiders. The venom from these spiders will be used to fight a specific type of cancer that is unique to Europe. The owners of the island have offered to sell it to DE for USD 8 million. DE would also be faced with additional initial costs of USD 12 million to engineer...
please fill in andwers in the yellow cells Toefield Inc. has developed a powerful efficient snow remover that is significantly less polluting than existing snow removers currently on the market. The company spent $2,000,000 developing this product and the marketing department spent ano ther $300,000 to assess the market demand. It would cost $20 million at Year 0 to buy the equipment necessary to manufacture the efficient snow blower. The project would require net working capital at the beginning of...
Toefield Inc. has developed a powerful efficient snow remover that is significantly less polluting than existing snow removers currently on the market. The company spent $2.000.000 developing this product and the marketing department spent another $300,000 to assess the market demand. It would cost $20 million at Year to buy the equipment necessary to manufacture the efficient snow blower. The project would require net working capital at the beginning of each year equal to 20% of sales (NOWCO - 20%(Sales)....
17. Chapter 5: Applying Excel: Exercise (Part 2 of 2) 2. Change all of the numbers in the data area of your worksheet so that it looks like this: Part 2 of 2 1 Chapter 5: Applying Excel pints eBook 3 4 5 6 | 7 Data Unit sales Selling price per unit Variable expenses per unit Fixed expenses 70,000 units $ 30 per unit $ 18 per unit $ 756,000 Print References If your formulas are correct, you should...
Quantitative Problem: Sunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC is considering the development of a new line of high-protein energy smoothies. SSC's CFO has collected the following information regarding the proposed project, which is expected to last 3 years: The project can be operated at the company's Charleston plant, which is currently vacant. The project will require that the company spend $4.9 million today (t = 0) to purchase additional equipment. This equipment is eligible for 100% bonus...
Warm Hands, a small company based in Prince Edward Island, manufactures and sells two types of lightweight gloves for runners—Warm and Cozy. Current revenue, cost, and unit sales data for the two products appear below: Warm Cozy Selling price per pair $8.00 $12.00 Variable expenses per pair $2.00 $6.00 Number of pairs sold monthly 1,200 units 400 units Fixed expenses are $3,510 per month. Required: 1. Assuming the sales mix above, do the following: a. Prepare a contribution format income...
Warm Hands, a small company based in Prince Edward Island, manufactures and sells two types of lightweight gloves for runners—Warm and Cozy. Current revenue, cost, and unit sales data for the two products appear below: Warm Cozy Selling price per pair $8.00 $12.00 Variable expenses per pair $2.00 $6.00 Number of pairs sold monthly 1,200 units 400 units Fixed expenses are $3,510 per month. Required: 1. Assuming the sales mix above, do the following: a. Prepare a contribution format income...
Quantitative Problem: Sunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC is considering the development of a new line of high-protein energy smoothies. SSC's CFO has collected the following information regarding the proposed project, which is expected to last 3 years: • The project can be operated at the company's Charleston plant, which is currently vacant. • The project will require that the company spend $4.1 million today (t = 0) to purchase additional equipment. For tax purposes the equipment...
Quantitative Problem: Sunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC is considering the development of a new line of high-protein energy smoothies. SSC's CFO has collected the following information regarding the proposed project, which is expected to last 3 years: • The project can be operated at the company's Charleston plant, which is currently vacant. • The project will require that the company spend $4.9 million today (t = 0) to purchase additional equipment. For tax purposes the equipment...
Question #1 a) A firm has an asset with a market value of $20,000 and a book value of $30,000. If its marginal tax rate is 25%, what will the net proceeds from selling the asset be? b) A firm has an asset with a market value of $10,000 and a book value of $4,000. If its marginal tax rate is 25%, what will the net proceeds from selling the asset be? Question #2 A firm believes it can generate...