INVESTMENT & FINANCING – END OF STUDIES PROJEC

Assignment.xlsx

Question 1

		Assignment 1
		Question 1
		Herbal Hair is a manufacturing company that produces shampoo.
		The company uses multiple machines to automate its manufacturing process.
		Currently, the industrial mixer is broken, and so hourly employees must manually mix the shampoo.
		The manual mixing process costs about $10,000 per month in labor for the upcoming 6 months until they get the permanent automatic machine.
		Meanwhile, Herbal Hair is considering investing in a temporary robot to mix the shampoo until it receives the permanent automatic machine.
		The initial cost of the robot is $60,000 which will save Herbal Hair the monthly labor costs associated with the mixing.
		Monthly maintenance fees for the robot are 500$/month.
		The required return is 1% per month.
		Is the temporary robot worth the money or should Herbal Hair continue to manually mix the shampoo for the next 6 months?

		Question 2
		Body Spice is a manufacturing company that produces liquid soap.
		The company uses multiple machines to automate its manufacturing process.
		Currently, the industrial mixer is broken, and so hourly employees must manually mix the liquid soap.
		The manual mixing process costs about $15,000 per month in labor for the upcoming 6 months until they get the permanent automatic machine.
		Meanwhile, Body Spice is considering renting in a temporary robot to mix the liquid soap until it receives the permanent automatic machine.
		The monthly rental cost of the robot is $10,000 which will save Body Spice the monthly labor costs associated with the mixing.
		Monthly maintenance fees for the robot are 5,000$/month.
		The required return is 2% per month.
		Is the temporary robot worth the money or should Body Spice continue to manually mix the liquid soap for the next 6 months?

Question 3
Canadian Snowflake and Norwegian Snowshoe are two companies		Canadian Snowflake	Norwegian Snowshoe
that sell winter sports goods.	Assets
	Cash	$ 47,500	$ 24,300
Please take a look at their Balance Sheets for the year ended Dec 31st, 2020.	AR	$ 21,500	$ 26,000
	Prepaid Insurance	$ 2,500	$ 1,800
a) Calculate all the financial ratios that you can given the information you have.	Inventory	$ 48,000	$ 45,500
	Land	$ 20,000	$ 10,000
b) Compare each financial ratio between each company.	Plant Assets	$ 230,000	$ 190,000
	Accumulated Depreciation	-$ 85,500	-$ 71,100
c) Can you come up with a conclusion? Which company is in a better	Total Assets	$ 284,000	$ 226,500
financial situation?
	Liabilities and Equity
	Liabilities:
	AP	$ 17,200	$ 19,000
	Salaries Payable	$ 1,900	$ 1,500
	Notes Payable (Long-term)	$ 85,000	$ 75,000
	Total Liabilities	$ 104,100	$ 95,500
	Equity:
	Common Stock	$ 115,000	$ 70,000
	Retained Earnings	$ 64,900	$ 61,000
	Total Equity	$ 179,900	$ 131,000
	Total Liabilities and Equity	$ 284,000	$ 226,500

		Question 4-a
		Mikael Katz is a fashion designer who sells leather goods. Currently, Mikael sells 10,000 belts a month.
		At the moment, Mikael imports the leather from China. He pays $1,000 in monthly shipping fees and $5/belt. He sells each belt for $30.
		Mikael is thinking of buying a machine that will help him brand the belts by engraving his MK monogram on the belt.
		The machine costs $60,000 and will add value to the belts which will now sell for $40 each.
		The machine has $500 monthly maintenance fees. The machine has a life of 12 months before it becomes obsolete.
		The machine has a $2,000 salvage value at the end of the 12 months.
		The required return is 1% per month.
		Should MK invest in the machine and sell engraved belts or should MK continue selling belts with no monogram?

		Question 4-b
		Mikael Katz decided on not buying the first machine.
		He is now thinking of buying a second machine that adds a hologram on each belt.
		The hologram prevents counterfeits and further adds value to the brand.
		Mikael could then sell each belt for 35$.
		Mikael doesn't know how much the machine costs, but he estimates that monthly maintenance fees will be around 750$.
		He also estimates that the machine has a life of 12 months before it becomes obsolete, and that it will not have a salvage value.
		The required return is 1% per month.
		How much money can MK spend on the second machine? What is the breakeven point?

		Question 4-c
		Mikael Katz decided on not buying the first machine, and on not buying the second machine.
		He is now thinking of buying or leasing a third machine that adds a serial number on each belt.
		The serial number prevents counterfeits and further adds value to the brand.
		Mikael could then sell each belt for 45$.
		Mikael can buy the third machine for $75,000, and pay a $750 monthly maintenance fee.
		The machine has a life of 12 months before it becomes obsolete, and that it will have a $1,000 salvage value.
		Alternatively, Mikael can lease the third machine for a $2,000 monthly fee, which includes maintenance fees.
		The required return is 1% per month.
		Should MK buy or lease the third machine? Or neither?