Business Administration - Accounting & Financial Planning ECN502 Lecture Notes - Lecture 1: Economic Methodology, Scientific Method

The following list, in alphabetical order, shows the various items that regularly appear on the financial statements of Maple Park Theatres Corp. The amounts shown for balance sheet items are balances as of September 30, 2017 (with the exception of retained earnings, which is the balance on September 1, 2017), and the amounts shown for income statement items are balances for the month ended September 30, 2017.

1. Using the data given, prepare an income statement for the month ended September 30, 2017.

2. Using the data given, prepare a statement of retained earnings for the month ended September 30, 2017.

3. Using the data given, prepare a balance sheet at September 30, 2017.

4. You have $1,000 to invest. You want to use it to buy stock in Maple Park? Which of the following information would you least consider before making a final decision?

I just need help with the chart at the bottom. Here is all the information for the company.

Accounts receivable for 2015__$300____

Total current assets= cash and marketable securities + account rec + inventory

1,542=347+a/r+895

Accounts rec = $300

Accounts payable for 2014__$319_____

Total Current Liabilities = Accrued Wages and taxes + Accounts Payable + Notes Payable
997 = 257 + Accounts Payable + 421
Accounts Payable = $319

c. Gross plant and equipment for 2015_$3,159______

Net Plant and Equipment = Gross Plant and Equipment – Depreciation
2,872 = Gross Plant and Equipment – 287
Gross Plant and Equipment = $3,159

d. Long-term debt for 2014__$132_____

Total Debt = Long-term Debt + Current Liabilities
1,129 = Long-term Debt + 997
Long-term Debt = $132

e. Common stock and paid-in surplus (250 million shares) for 2014 $300

Total Equity = Preferred Stock + Common Stock and paid surplus + Retained Earnings
1,472 = 30 + Common Stock and paid surplus + 1,142
Common Stock and paid surplus = $300

f. Total FA for 2015 $3,393

Total FA = Net Plant and Equipment + Other long-term assets
Total FA = $2,872 + 521
Total FA = $3,393

g. Net sales for 2015_______

Net Sales – Cost of Goods Sold = Gross Profit

Net Sales – 987 = 1,396

Net Sales = $2,383

h. Less: Cost of goods sold for 2014_______

Net Sales – Cost of Goods Sold = Gross Profit
2,018 - Cost of Goods Sold = 1,189
Cost of Goods Sold = $829

i. Less: Interest for 2015_______

EBIT- Interest = EBT
1,086 – Interest = 949
Interest = $137

j. Less: Taxes for 2015_______

Net Income = EBT – Taxes
644 = 949 – Taxes
Taxes = $305

k. Earnings per share (EPS) for 2015_______

Earning per share for 2015 = Net Income available to Common Stockholders / No of Common Stocks

Earning per share =566 / 250

Earning per share = $2.27 per share

l. Dividends per share (DPS) for 2014_______

Dividend per share = Common stock Dividend/ No of Common Stocks

Dividend per share = 219/250

Dividend per share = $0.88 per share

m. Book value per share (BVPS) for 2015_______

Book value per share= total common stockholder’s equity/No of Common Stocks

Book value per share= 1,789/250

Book value per share= 7.16

n. Net income $664

o. Increase in accrued wages and taxes $309-$257= $52

p. Increase in inventory –(895-797)= $ -98

q. Net cash flow from operating activities 664+287+52+62-41-98=$926

r. Increase in other long-term assets –(521-487)= $-34

s. Net cash flow from investing activities -343-34=-377

t. Increase in notes payable 492-421= 71

u. Pay dividends 98+219= 317

v. Net cash flow from financing activities 71+147-317= -99

w. Plus: Net income for 2015 $664

x. Preferred stock $98

Worldwide Widget Manufacturing, Inc.

A. Use the information found in Worldwide Widget Manufacturing’s financial statements to calculate all of the listed financial ratios in the above table for your company. Then, for each ratio, provide a comparison of the company’s result with the industry standards, indicating if your company’s results are lower than, higher than, slower than, or faster than the industry standards.

B. Calculate your company’s internal and sustainable growth rates.

Create a Multi-Step Income Statement, Statement of Retained Earnings, Classified Balance Sheet and Statement of Cash Flows. These financial statements are being prepared for the fiscal month ending May 31st. Build the financial statements within the given blanks. The month of May's worksheet is to be utilized while creating the financial statements. Additional information folows:

-For the Statement of Retained Earnings, assume a beginning balance in the Retained Earnings account of $366,000. Also assume that $345,500 of dividends were declared.

-For the Classified Balance Sheet, assume that the company only has common stock and that the value of common stock at par value equals $30,200. Further assume that the value of paid-in-capital excess of par on the common stock has a value of $1,560,000.

-For the Statement of Cash Flow assume that the company purchased equipment with $200,000 cash. The company sold land and received $429,000 in cash. Also assume the following ending balances from the last financial period: Cash: $345,091; A/R: $525,000; Inventory: $836,000; Office Supplies: $5,000; A/P: $675,800. Additionally, the company paid cash dividends during the period of $345,500. Create the Statement of Cash Flow using the Indirect Method.

Worksheet for May