Question

$10.00 Chap 14- 6, 7 and 8 solution in excel

Found in Business: Finance
Chapter 1, # 0
Posted by :
limra
limra Not confirmed
Rating (343):A
Questions Asked: 1
Tutorials Posted: 726,
Earned: $24,504.44
 
 
Q:

14-6)  Following are financial statements for the Genatron Manufacturing corporation for 2012 and 2011.

GENATRON MANUFACTURING CORPORATION

Balance Sheet                                                                  2012                                            2011

Assets

Cash                                                       $40,000                                    $50,000

Accts. Receivable                                      260,000                                     20,000

Inventory                                                 500,000                                     450,000

Total current assets                                   800,000                                     700,000

Fixed assets, net                                       400,000                                     300,000

Total assets                                          $1,200,000                                $1,000,000

LIABILITIES AND EQUITY                    2012                              2011

Accts. Payable                             $170,000                  130,000

Bank Loans                                    90,000                    90,000

Accruals                                         70,000                    50,000

Total current liabilities                    330,000                  270,000

Long-term debt, 12%                     400,000                  300,000

Common stock, $10 par                 300,000                  300,000

Capital surplus                               50,000                    50,000

Retained earnings                        120,000                    80,000

Total liabilities & equity            $1,200,000              $1,000,000

 

INCOME STATEMENT                                              2012                                        2011

Net sales                                              $1,500,000                   $1,300,000

Cost of goods                                            900,000                       780,000

Gross Profit                                                600,000                       520,000

Expenses: general and admin                      150,000                       150,000

Marketing                                                  150,000                       130,000

Depreciation                                                53,000                         40,000

Interest                                                      57,000                         45,000

Earnings before taxes                                 190,000                       155,000

Income taxes                                              76,000                        62,000

Net income                                              $114,000                       $93,000

14-7)  This problem uses the financial statements for the Genatron Manufacturing corporation for the years 2012 and 2011 from Problem 6.

14-8)  Genatron manufacturing expects its sales to increase by 10 % in 2013.  Estimate the firm's external financing needs by using the percent-of-sales method for the 2012 data.

 

 

Tutorial
 
$10.00
Chap 14- 6, 7 and 8 solution in excel
  • This tutorial was purchased 7 times and rated No Rating by students like you.
  • Posted on Jul. 01, 2012 at 12:00:33AM
A:
Preview: ... attach ...

The full tutorial is about 5 words long plus attachments.

attachmentlogo

Attachments:
chap 14 genatron solution.xlsx (17K)