Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show steps O 1. Your new boss Wally Oliver is pleased with your work! He has given you another assignment. It is Dec 31,
please show steps
O 1. Your new boss Wally Oliver is pleased with your work! He has given you another assignment. It is Dec 31, 2015 and Wally asks you to create financial statements for a new company owned by Lexi Holding. The company, called Madi Sporting Goods, started operations Jan 1, 2015 and sells sports equipment. Given that you want to keep your job - and that you like doing this stuff - you agree. Through discussions with Wally and documents he provides to you, you get much information. This information is listed below. Wally asks that you compile an income statement and balance sheet. Sales were $1,000,000 in 2015 Gross profit margin was 60% Operating margins were 12% The Bank of Toronto provided a loan on Jan 1, 2015 worth $300,000. The annual interest is 8% and is compounded annually. Interest only payments are needed - until the loan is due in 10 years, where a balloon payment for the full balance must be paid. The combined federal and provincial tax rates is 27% The ending cash balance in Madi Sporting Goods is 200,000. Accounts Receivables is 10% of sales Inventory is 15% of sales Accounts Payable is 5% sales Accrued expenses payable is 5.5% of sales Capital equipment purchases were made at the start of the year. These total $50,000. These depreciate at 10% per year Lexi Holding's owner, Mr. X, provided all other capital in the form of equity financing o o o o o o o o o Wally asks you to figure out his SG&A (Selling General and Administrative expenses). (Income Statement 10 marks, Balance Sheet 15 marks) o 2. It is December 31, 2016 and Wally needs your help again. He wants you to create his Income Statement for 2016. Please use the following information to create the 2016 Income Statement. 2016 sales were 125% of 2015 sales Gross profit margin was 55% o Operating profit margins were 15% Interest expense fell to 7%, given a change in interest rates The tax rate was 30% o o o (10 marks) 3. Wally says that Lauren created the Balance Sheet for December 31, 2016. Wally asks you to use the Income Statement you created (in 2 above) and the Balance Sheet Lauren created (in appendix B1) to complete a cash flow statement. You agree to create a cash flow statement for 2016. Note you will need to figure out how much was paid out to Lexi Holdings as a dividend. Finally, he asks you to share any observations you might have on Madi Sporting Goods based on what you have put togetherStep 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