Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  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% of 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 Holdings owner, Mr. X, provided all other capital in the form of equity financing
    • Wally asks you to figure out his SG&A (Selling General and Administrative expenses).

  1. 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%
    • Operating profit margins were 15%
    • Interest expense fell to 7%, given a change in interest rates
    • The tax rate was 30%
  2. 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 together.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Studies Of Company Records (RLE Accounting)1830-1974

Authors: J. R. Edwards

1st Edition

1138983306, 9781138983304

More Books

Students also viewed these Accounting questions