Question

In: Finance

Chapter 16 Homework Lewis Company Pro Forma Income Statement December 31, 2007 (Thousands of Dollars)                   ...

Chapter 16 Homework

Lewis Company

Pro Forma Income Statement

December 31, 2007

(Thousands of Dollars)

                   2007                                                   Sales              $8,000                                            Operating costs    7,450                                                     EBIT               $ 550                           

Interest              150                         

EBT                $ 400                           

Taxes (40%)           160                          

Net income         $ 240                          

Less: Dividends:

$1.04 ´ 150 =     $ 156  

Addition to R.E.= $   84

Lewis Company

Pro Forma Balance Sheet

December 31, 2007

(Thousands of Dollars)

                       

              2007

Cash         $   80   

Receivables     240   

Inventories    720   

Total current

    assets   $1,040   

Fixed assets 3,200   

Total assets $4,240  

Accounts

Payable        160   

Accrued liab.    40   

Notes payable   252                        

Total current

liabilities $ 452                    

Long-term

debt          1,244                     

Total debt   $1,696                      

Common stock 1,605                       

Retained

Earnings       939              

Total liabilities

         and equity   $4,240                     

On a separate piece of paper (preferably using Excel), complete the following exercises.

        

It expects sales to increase by 20% during 2008 and expects dividends per share to increase to $1.10, based upon 150 shares outstanding. Fixed Assets are closely tied to sales levels. Use the Percent of Sales method to project the 2008 financial statements for the firm. How much AFN doe the firm require?

The firm must maintain a current ratio of 2.3 and a total debt to capital ratio of 40%. How much financing will be obtained using notes payable, long-term debt and common stock?

Solutions

Expert Solution

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. 1.Create the pro forma statements. 2. What’s the plug variable here? 3. If Fire Corp pays half of income as dividend,...
Mariner, Inc. Comparative Income Statement Years Ended December 31, 2019 and 2018 Dollars in thousands                          &
Mariner, Inc. Comparative Income Statement Years Ended December 31, 2019 and 2018 Dollars in thousands                                                                 2019              2018                          2017 Net Sales Revenue                             $177,000           $154,000 Cost of Goods Sold                              94,000              87,500 Selling and Administrative Expenses   47,000                 39,500 Interest Expense                                8,500                 11,500 Income Tax Expense                   12,500                    9,500 Net Income                                 $15,000                     $6,000 Additional data: Total Assets                                    $202,000            $191,000           $171,000 Common Stockholders' Equity          94,500                86,500               80,000 Preferred Dividends                         2,000                       2,000                  0 Common Shares Outstanding During the Year            25,000            25,000     20,000 1. Calculate the profit...
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company...
Pro forma income statement. Given the income statement in the popup​ window, for California Cement Company for 2013 and an expected sales growth rate of 6.61 % for​ 2014, prepare a pro forma income statement for 2014. First, find the percentage of each income statement line from 2013 as a percent of sales. ​(Round to three decimal​ places.) Sales Revenue $22,811,000 ____ % Cost of goods sold $-11,638,000 ___% Selling, general, and administrative expenses $-3,973,000 ____% Depreciation expenses $ -1,369,000...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A for a 5-year period and a terminal year, based on various assumptions, which already have been completed. Company A Income Statement For the Years Ended 2017 2018 2019 2020 2021 2022 Terminal year 2023 Sales     550.00            825.00               990.00                  1,138.50                    1,252.35                    1,340.01                        1,393.62                 1.50 (825*120%) (990*115%) (1138.50*110%) (1252.35*107%) (1340.01*104%) Cost of Sales     275.00            288.75              ...
Develop a pro forma income statement and balance sheet for the company given below. Use the...
Develop a pro forma income statement and balance sheet for the company given below. Use the following assumptions in making your pro forma: Currently, fixed assets are at full capacity Each asset grows proportionally with sales Payables and accruals grow proportionally with sales 2017’s profit margin (2.52%) and dividend payout (30%) will be maintained in 2018 Sales are projected to increase by $500 million (25%) Interest payments will not change (this is not realistic, but will save you some steps)...
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                 
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                              2017      2018                                                                            2017      2018 Cash                                 30            25                  Account Payable                                  35          50 Accts Receivable          5              20                  Bank Loan                                            25           25 Inventory                        100         100                Accrued Taxes                                   15          25 Current Assets              135          245                Long Term, Dept current portion    12         12                                                                                  Current Liabilities                                87         112 Net Plant & Equip           200          250                 Long-Term Dept                                100        95                                                                                  Common Stock (10,000 shares)    100      100                                                                                 Additional paid-in...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $92,316 $104,544 Event-related revenue 135,648 131,648 NASCAR broadcasting revenue 179,922 170,368 Other operating revenue 63,114 77,440 Total revenue $471,000 $484,000 Expenses and other: Direct expense of...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $94,400 $107,580 Event-related revenue 138,768 147,189 NASCAR broadcasting revenue 169,448 160,881 Other operating revenue 69,384 73,350 Total revenue $472,000 $489,000 Expenses and other: Direct expense of...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Motor Speedways Inc., owner and operator of several major motor speedways. Current Year Previous Year Revenues: Admissions $89,870 $102,690 Event-related revenue 145,684 147,189 NASCAR broadcasting revenue 170,753 161,859 Other operating revenue 66,693 77,262 Total revenues $473,000 $489,000 Expenses and other: Direct expense of events $97,911 $97,800 NASCAR purse and sanction fees 116,358 117,849...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT