Question

In: Accounting

It is Dec 31, 2015 and Mr. X is reflecting on the first year of his...

It is Dec 31, 2015 and Mr. X is reflecting on the first year of his new business, OBD Inc. He has hired you to create financial statements for the company and you agree. You interview him – and he shares with you a great deal of information – which is listed below. He asks that you compile an income statement and balance sheet.

Sales were $1,000,000

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%

Mr. X knows that the ending cash balance in his company 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

Mr. X will provided all other capital in the form of equity financing

As a smart young consultant, Mr. X has asked you to figure out his SG&A (Selling General and Administrative expenses).

Solutions

Expert Solution

OBD Inc.
Income Statement
For the Year Ended December 31, 2015
Sales 1000000
Cost of goods sold 400000
Gross profit (60% x $1000000) 600000
Operating expenses:
Depreciation expense 5000
Selling and administrative expense 475000
Operating income (12% x $1000000) 120000
Interest expense (8% x $300000) 64000
Income before income taxes 56000
Income tax expense (27% x $56000) 15120
Net income 40880
OBD Inc.
Balance Sheet
December 31, 2015
Assets
Cash 200000
Accounts receivable (10% x $1000000) 100000
Inventory (15% x $1000000) 150000
Equipment 50000
Less: Accumulated depreciation (10% x $50000) -5000
Total assets 495000
Liabilities and Owner's Equity
Accounts payable (5% x $1000000) 50000
Accrued expenses payable (5.5% x $1000000) 55000
Long-term loan payable 300000
Capital 49120
Retained earnings 40880
Total liabilities and owner's equity 495000

Related Solutions

Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
Dec. 31, Year 2 Dec. 31, Year 1 ASSETS Current assets: Cash and cash equivalents $...
Dec. 31, Year 2 Dec. 31, Year 1 ASSETS Current assets: Cash and cash equivalents $ 92,069   $ 72,634 Accounts receivables, net 55,947 75,492 Inventories 50,784 53,129 Prepaid expenses    12,112    13,057 Total current assets 210,912 214,312 Equipment 145,444 134,312 Less: Accumulated depreciation (50,515) (36,689) Total assets $305,841 $311,935 LIABILITIES AND STOCKHOLDERS’ EQUITY Current liabilities: Accounts payable $ 25,466 $ 34,879 Accrued liabilities     40,574     40,722 Total current liabilities     66,040     75,601 Long-term debt     10,422    ...
Our firm purchased equipment for US$100,000 on Dec 1, 2015. Our year end is December 31,...
Our firm purchased equipment for US$100,000 on Dec 1, 2015. Our year end is December 31, and the payable is due on Jan 31, 2016. On December 1, 2015, we entered into a forward exchange contract with the bank to provide us with the US dollars on January 31, 2016. The following rates were in effect: Forward Rates: Dec1,2015; 60 day forward rate US$1= CDN$1.152 Dec 31, 2015; 30 day forward rate US$1 = CDN$ 1.162 Spot rates Dec 1,...
Langley Company's December 31 year-end financial statements contained the following errors: Dec. 31, 2017 Dec. 31,...
Langley Company's December 31 year-end financial statements contained the following errors: Dec. 31, 2017 Dec. 31, 2018 Ending inventory $27,500 understated $35,000 overstated Depreciation expense 10,000 overstated An insurance premium of $290,000 was prepaid in 2017 covering the years 2017, 2018, and 2019. The prepayment was correctly recorded with a debit to prepaid insurance. However, the prepaid insurance account at December 31, 2018 had a balance of $290,000. (a) What is the total net effect of the errors on the...
You are given the following information. Please use it for the following 31-Dec-16 31-Dec-16 31-dec-17 31-Dec-17...
You are given the following information. Please use it for the following 31-Dec-16 31-Dec-16 31-dec-17 31-Dec-17 stock Price Shares Price Shares w 50$ 10000 25$ 20000 x 40$ 5000 25$ 10000 y 20$ 20000 30$ 20000 z 30$ 15000 40$ 15000 Stocks W and X had 2 for 1 splits on December 31, 2016. The information in the table for 2016 is pre-split. 3.4 Calculate the price weighted series for Dec 31, 2016, prior to the splits. 3.5 Calculate the...
Cash and cash equivalents, Dec. 31 prior year-end $ 45,000 Cash and cash equivalents, Dec. 31...
Cash and cash equivalents, Dec. 31 prior year-end $ 45,000 Cash and cash equivalents, Dec. 31 current year-end 126,540 Cash received as interest 4,500 Cash paid for salaries 130,500 Bonds payable retired by issuing common stock (no gain or loss on retirement) 140,000 Cash paid to retire long-term notes payable 225,000 Cash received from sale of equipment 110,250 Cash received in exchange for six-month note payable 45,000 Land purchased by issuing long-term note payable 81,200 Cash paid for store equipment...
Dec 31 Industry Average Balance Sheet (000)           2015   2016   2017   $ % of TA   $ %...
Dec 31 Industry Average Balance Sheet (000)           2015   2016   2017   $ % of TA   $ % of TA   $ % of TA   Assets Current assets Cash   1,512 6.81%   1,176 3.6%   1,097 2.3%   6% Accounts receivable   6,237 28.09%   10,271 31.2%   15,919 33.4%   20% Inventories   4,536 20.43%   7,838 23.8%   12,570 26.4%   31% Prepaid expenses   3,780 17.02%   5,140 15.6%   6,840 14.3%   5% Total current assets 16,065 72.35%   24,425 74.2%   36,426 76.4%   62% Gross fixed assets   6,300 28.37%   9,080 27.6%   12,918 27.1%   25% Less:...
Period End Date 31-Dec-19 31-Dec-18 31-Dec-17 31-Dec-16 31-Dec-15 Total Inventories 17516000000 16450000000 15296000000 14760000000 14001000000 Cost...
Period End Date 31-Dec-19 31-Dec-18 31-Dec-17 31-Dec-16 31-Dec-15 Total Inventories 17516000000 16450000000 15296000000 14760000000 14001000000 Cost of Goods Sold incl. Depreciation 211248000000.00 163041000000.00 156258000000.00 148623000000.00 126762000000.00 Net Sales or Revenue 256577000000.00 194578000000.00 184786000000.00 177526000000.00 153290000000.00 Accounts Receivable Gross 17555000000 17303000000 13342000000 12450000000 12049000000 Accounts Payable 30972000000 26437000000 19223000000 17397000000 15143000000 Find the Operating cycle and Cash cycle (show work).
SRP Ltd has the following unadjusted trial balance as at 31 Dec 2015. Account Titles Debit...
SRP Ltd has the following unadjusted trial balance as at 31 Dec 2015. Account Titles Debit ($) Credit ($) Cash 19,600 Accounts Receivable 7,000 Supplies 1,300 Prepaid Insurance 900 Equipment 27,000 Accumulated Depreciation 12,000 Other Assets 5,100 Accounts Payable 7,500 Share Capital (3000 shares outstanding all year) 16,000 Retained Profit 10,300 Service Revenue 48,000 COGS 32,900 Total 93,800 93,800 Note: Data not yet recorded as at 31 Dec 2015 includes the following five (5) transactions: 1) Depreciation expense for 2015...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT