Question

In: Accounting

How would you interpret the below financials? Income Statement - Quarter 3       Gross Revenue...

How would you interpret the below financials?

Income Statement - Quarter 3
     
Gross Revenue    3,182,084 100.0%
- Commissions       285,359    9.0%
- Refunds       187,743    5.9%
+ Interest Income                  -      0.0%
Net Revenue       2,708,982 85.1%
     
Flight Operations       646,112    20.3%
Fuel       573,887    18.0%
Maintenance       565,530    17.8%
Passenger Service       443,330    13.9%
Cabin/Food Service         45,478    1.4%
Insurance         66,000    2.1%
Marketing Expenses         31,000    1.0%
Add. Employee Compensation           8,400    0.3%
Quality and Training           4,000    0.1%
Hiring/On-Job-Training Costs         18,000    0.6%
Social Performance Budget               500    0.0%
Market Research Cost                  -      0.0%
Interest Expense         33,977    1.1%
Lease Payment       502,000    15.8%
Administrative Exp       200,000    6.3%
Depreciation           5,000    0.2%
Other Expense           6,771    0.2%
Total Operating Expense       3,149,985 99.0%
Operating Profit/Loss        (441,003) -13.9%
     
Net Cargo Profit           3,820    0.1%
Other Income                  -      0.0%
Profit Before Tax        (437,183) -13.7%
     
Less Income Tax (40%)                  -      0.0%
Net Profit        (437,183) -13.7%
Dividends Paid                     -   0.00/sh
Current QuarterYear To-Date
Balance Sheet - Quarter 3
     
Cash             243,678
Short-term Investment                        -     
Accounts Receivable          1,272,834   
Total Current Assets           1,516,512
     
Aircraft Cost                        -     
Less Depreciation                        -     
Net Aircraft                        -     
Facilities/Equipment-Net               65,000   
Total Fixed Assets                 65,000
     
Total Assets           1,581,512
     
Accounts Payable             943,496   
Short-term Loans             937,268   
Total Current Liabilities           1,880,764
     
Long-term Loans             260,439   
Total Liabilities           2,141,203
     
Common Stock          1,525,000   
Retained Earnings        (2,084,690)   
Total Equity             (559,690)
     
Total Liabilities & Equity           1,581,513
Cash Flow - Quarter 3
     
Beginning Cash              219,281
CD Redemption                         -     
Gross Revenue (60%)           1,909,250   
Accounts Receivable           1,039,620   
Stock Issued                         -     
Loan Proceeds                         -     
Other Income              469,820   
     
Total Cash Inflow (a)           3,637,971
     
Commissions + Refunds              473,102   
Operating Expense (70%)           2,201,489   
Accounts Payable              714,385   
Income Tax                         -     
Total Loan Payments                  5,315   
CD Purchase                         -     
Dividends                         -     
Equipment Purchases                         -     
     
Total Cash Outflow (b)           3,394,291
     
Net Cash (a)-(b)               243,680
Overdraft Loan                         -  
     
Ending Cash               243,680
     
  
     

Solutions

Expert Solution

Answer    Interpretations of Financial statements.

•             Company business operating ratio is( 1.16)is very high because company operating   expenses are too high, this is reason company getting net operating loss from business from current quarter as well a large amount of accumulated loss in balance sheet.

•             Due to loss there is no tax liability due on company this quarter.

•             Due to current quarter and accumulated loss, company also not declare and paid any dividend.

•             There are big amount outstanding of company debtors and accounts receivable. Also company has low cash balance, this will create liquidity problem to company in near future.

•             Company debt equity ratio is very low (78%), which show high cost of capital of equity capital.   But company’s getting loss continuously and will not able to fixed interest and other expenses on his debt, so company debt- equity ratio is ok.

•             Company has a big amount of outstanding short term loans which require to pay within a year, but company liquid assets is not enough to pay his loans and other liabilities. So company will face liquidity problem in very near future.

•             Cash flow of company improves than previous quarter.


Related Solutions

How would you interpret the below financials? Income Statement - Quarter 4       Gross Revenue...
How would you interpret the below financials? Income Statement - Quarter 4       Gross Revenue    3,149,864    100.0% - Commissions       282,397    9.0% - Refunds       239,389    7.6% + Interest Income                  -      0.0% Net Revenue       2,628,078 83.4%       Flight Operations       641,849    20.4% Fuel       593,729    18.8% Maintenance       561,836    17.8% Passenger Service       430,489    13.7% Cabin/Food Service         38,562    1.2% Insurance         66,000    2.1%...
How would you interpret the below financial statements? Income Statement - Quarter 1       Gross...
How would you interpret the below financial statements? Income Statement - Quarter 1       Gross Revenue           1,458,932       100.0% - Commissions              128,612    8.8% - Refunds                97,748    6.7% + Interest Income                        -      0.0% Net Revenue 1,232,572 84.5%       Flight Operations             299,590    20.5% Fuel             257,205    17.6% Maintenance             274,102    18.8% Passenger Service             212,316    14.6% Cabin/Food Service                17,776    1.2% Insurance                17,640    1.2% Marketing...
How to explain and classify income statement revenue, gross profit, and net income?
How to explain and classify income statement revenue, gross profit, and net income?
17-3 17-01 Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for...
17-3 17-01 Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $559,000 $503,000 Cost of goods sold 301,860 246,470 Selling expenses 100,620 100,600 Administrative expenses 111,800 95,570 Income tax expense 16,770 25,150 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive...
Below are the past two years of financials for Field of Dreams, LLC: INCOME STATEMENT: 2016...
Below are the past two years of financials for Field of Dreams, LLC: INCOME STATEMENT: 2016 2017 Sales $100,000.00 $138,600.00 Cost of Goods Sold $60,000.00 $83,160.00 Gross Margin $40,000.00 $55,440.00 Depreciation $16,000.00 $19,200.00 Administrative Costs $9,000.00 $10,800.00 EBIT $15,000.00 $25,440.00 Interest $4,000.00 $4,000.00 Pre-tax income $11,000.00 $21,440.00 Taxes $4,400.00 $8,576.00 Net Income $6,600.00 $12,864.00 Dividends $0.00 $7,718.40 Addition to Retained Earnings $6,600.00 $5,145.60 BALANCE SHEET AS OF 12/31/2017: ASSETS 2016 2017 Cash $5,000.00 $6,000.00 Inventory $15,000.00 $18,000.00 Accounts Receivable $15,000.00...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc.
Vertical Analysis of Income StatementRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current year AmountPrevious year AmountSales$450,000 $387,000 Cost of goods sold$270,000 $212,850 Selling expenses$72,000 $69,660 Administrative expenses$76,500 $61,920 Income tax expense$13,500 $15,480 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.b. The vertical analysis indicates that the cost...
Presented below is the income statement of Cowan, Inc.:          Sales revenue                      &nbsp
Presented below is the income statement of Cowan, Inc.:          Sales revenue                                                                        $380,000          Cost of goods sold                                                                 225,000          Gross profit                                                                             $155,000          Operating expenses                                                                   95,000          Income before income taxes                                                      60,000          Income taxes                                                                              24,000          Net income                                                                             $ 36,000 In addition, the following information related to net changes in working capital is presented:                                                                                                               Debit                  Credit          Cash                                                                                         $12,000          Accounts receivable                                                                   25,000          Inventories                                                                                                              $19,400          Salaries payable (operating expenses)                                        8,000         ...
Presented below is the income statement of Cowan, Inc.:          Sales revenue                      &nbsp
Presented below is the income statement of Cowan, Inc.:          Sales revenue                                                                         $380,000          Cost of goods sold                                                                    225,000          Gross profit                                                                             $155,000          Operating expenses                                                                    95,000          Income before income taxes                                                      60,000          Income taxes                                                                              24,000          Net income                                                                             $ 36,000 In addition, the following information related to net changes in working capital is presented:                                                                                                               Debit                     Credit          Cash                                                                                          $12,000          Accounts receivable                                                                   25,000          Inventories                                                                                                              $19,400          Salaries payable (operating expenses)                                        8,000          Accounts payable                                                                                                     14,000         ...
Below is an expert from a company’s income statement for the first quarter. What is the...
Below is an expert from a company’s income statement for the first quarter. What is the cost behavior associated with each expense? (Each cost behavior can be used once, multiple times, or not at all.) January February March Units Sold 6,000 8,000 5,000 Depreciation Expense 900 1,100 800 Accounting Expense 1,800 2,400 1,500 Advertising Expense 960 960 960       -       A.       B.       C.    Depreciation Expense       -       A.   ...
An income statement for Iyekqv603 Corp. for the first quarter of the year is presented below:...
An income statement for Iyekqv603 Corp. for the first quarter of the year is presented below: Iyekqv603 Corp. Income Statement For Quarter Ended March 31 Sales $ 910,000 Cost of goods sold 645,000 Gross margin 265,000 Selling and administrative expenses Selling $ 103,000 Administration 110,000 213,000 Net operating income $ 52,000 On average, a book sells for $65. Variable selling expenses are $6 per book with the remaining selling expenses being fixed. The variable administrative expenses are 5% of sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT