Question
Use the following information to answer all questions: Management of XYZ are considering investing in a new business line for producing a new product. The
Use the following information to answer all questions: | |||
Management of XYZ are considering investing in a new business line for producing a new product. The following data are relevant to the business line: | |||
1 | Business line machinery will cost $1,000,000 and have 10 years useful life and requires $50,000 maintenance annually | ||
2 | Line will have a normal capacity to produce 100,000 units annually | ||
3 | The line will be based in a factory rented and used by XYZ at $100,000 of which 40% will be allocated and charged to the business line. | ||
4 | Below are the materials used in producing the product: | ||
Quantity | Cost | ||
RM1 | 0.1 KG | $200 per KG | |
RM2 | 1 piece | $100 per box of 20 pieces | |
5 | Salaries are paid as follows: | ||
Head office salaries | $100,000 | annually | |
Factory labor | $200,000 | annually | |
Sales staff | $120,000 | annually | |
6 | XYZ will charge the business line $50,000 annually for Administration services (such as accounting, HR and other service) | ||
7 | At the end of year 5, the business line will be closed and the machinery will be sold to a third party for $450,000 | ||
8 | The investment and required working capital will be financed with 60% equity and 40% debt. | ||
9 | The new line is planned to produce and sell 50,000 units in year 1, 60,000 units in year 2 growing by 10% for the remaining years | ||
10 | Selling price for the product will be $50 per unit expected to rise by 10% starting year 3 | ||
11 | Raw materials are imported from a foreign country and their prices are expected to increase by an annual inflation rate of 7% | ||
12 | Working Capital: | ||
Sales are 20% cash and 80% credit due within 60 days | |||
Raw Material purchase are made on credit due within 30 days | |||
Factory rent is paid in advance on December 31 of each year | |||
13 | The company's dividend policy is 40% of net profit starting year 2 for this project (i.e. no dividend on year 1 net profit) | ||
14 | Cash balance should be minimum of100,000 | ||
15 | Debt to be paid over 2 years |
1)The expected dollar sales in year 1:
. 3.500.000
b. 2.500.000
c. 2.000.000
d. 3.000.000
2)Expected dollar sales in year 4:
. 4.392.500
b. 4.392.300
c. 4.932.300
d. 3.630.000
3)Expected cash collections in year2;
a. 2.100.000
b. 3.100.000
c. 2.650.000
d. 2.920.000
4)Assume no ending inventory, the total material cost for year 1 is:
. 1.605.000
b. 1.284.000
c. 1.000.000
d. 1.250.000
5)Cash payments for martials for year 2
. 1.575.417
b. 1.540.816
c. 2.195.589
d. 1.865.411
6)labor cost for year 2:
a. 300.000
b. 200.000
c. 180.000
d. 400.000
7)Assume that salvage value for the line is 0, the company uses straight line depreciation method.
What is the total overhead cost for year 1:
. 190.000
b. 150.000
c. 90.000
d. 140.000
8)The total cash selling and admin expenses for year 1 is:
a. 120.000
b. Non of the above
c. 190.000
d. 170.000
9)The gross margin for year 1 is:
. 1.640.000
b. 835.000
c. 1.005.000
d. 860.000
10)The operating income for year 1 is:
a. 835.000
b. 590.000
c. 690.000
d. 1.180.915
11)the net profit for year 1 is:
. 590.000
b. 490.000
c. 935.000
d. 690.000
12)Total assets by the end of year 1:
a. 1.123.673
b. 2.094.877
c. 1.440.000
d. 1.841.417
13)Cash Excess (Deficiency) for year1:
a. 645.833
b. -645.833
c. 545.833
d. -445.833
e. 445.833
f.-545.833
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started