Question

In: Accounting

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 Expenses                30,000    2.1%
Add. Employee Compensation                        -      0.0%
Quality and Training                  1,000    0.1%
Hiring/On-Job-Training Costs                12,000    0.8%
Social Performance Budget                     500    0.0%
Market Research Cost                        -      0.0%
Interest Expense                34,219    2.3%
Lease Payment             132,000    9.0%
Administrative Exp             100,000    6.9%
Depreciation                19,000    1.3%
Other Expense                  9,000    0.6%
Total Operating Expense         1,416,348 97.1%
Operating Profit/Loss           (183,776) -12.6%
     
Net Cargo Profit                        -      0.0%
Other Income                        -      0.0%
Profit Before Tax           (183,776) -12.6%
     
Less Income Tax (40%)                        -      0.0%
Net Profit           (183,776) -12.6%
Dividends Paid                         -  

0.00/sh

Current QuarterYear To-Date
Balance Sheet - Quarter 1
     
Cash             556,635
Short-term Investment                        -     
Accounts Receivable             583,573   
Total Current Assets           1,140,208
     
Aircraft Cost             800,000   
Less Depreciation           (320,000)   
Net Aircraft             480,000   
Facilities/Equipment-Net               75,000   
Total Fixed Assets               555,000
     
Total Assets           1,695,208
     
Accounts Payable             419,204   
Short-term Loans             937,268   
Total Current Liabilities           1,356,472
     
Long-term Loans             271,177   
Total Liabilities           1,627,649
     
Common Stock          1,525,000   
Retained Earnings        (1,457,440)   
Total Equity                 67,560
     
Total Liabilities & Equity           1,695,209
     
Cash Flow - Quarter 1
     
Beginning Cash              735,596
CD Redemption                         -     
Gross Revenue (60%)              875,359   
Accounts Receivable              524,258   
Stock Issued                         -     
Loan Proceeds                         -     
Other Income                         -     
     
Total Cash Inflow (a)           2,135,213
     
Commissions + Refunds              226,360   
Operating Expense (70%)              978,144   
Accounts Payable              368,540   
Income Tax                         -     
Total Loan Payments                  5,534   
CD Purchase                         -     
Dividends                         -     
Equipment Purchases                         -     
     
Total Cash Outflow (b)           1,578,578
     
Net Cash (a)-(b)               556,635
Overdraft Loan                         -  
     
Ending Cash               556,635
     

  

  

Solutions

Expert Solution

•             Company business operating ratio is( 97%)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. This will create liquidity problem to company in near future.

•             Company debt equity ratio is very low (79%), 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 are also not satisfactory, in this cash flow a big amount of refund include which will never happened frequently in future.


Related Solutions

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...
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%...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement:...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement: Sales revenue $ 194,000 $ 168,000 Cost of goods sold 113,000 100,400 Gross profit 81,000 67,600 Operating expenses and interest expense 56,400 53,200 Pretax income 24,600 14,400 Income tax 8,400 4,200 Net income $ 16,200 $ 10,200 Balance sheet: Cash $ 4,400 $ 7,200 Accounts receivable (net) 14,200 18,200 Inventory 40,400 34,200 Property and equipment (net) 45,600 38,400 Total assets $ 104,600 $ 98,000...
1. How are the different key financial statements interrelated (Income Statement, Balance Sheet, Cash Flow Statement)...
1. How are the different key financial statements interrelated (Income Statement, Balance Sheet, Cash Flow Statement) ? 2. What is the purpose and concept for each of these financial statements?
A) Portions of the financial statements for Horizon Telecom are provided below.   HORIZON TELECOM Income Statement...
A) Portions of the financial statements for Horizon Telecom are provided below.   HORIZON TELECOM Income Statement For the Year Ended December 31, 2021 Revenues $ 615,000 Expenses: Cost of goods sold $ 370,000 Operating expenses 117,000 Depreciation expense 33,000 Income tax expense 47,500 Total expenses 567,500 Net Income $ 47,500 HORIZON TELECOM Selected Balance Sheet Data December 31, 2021 Increase in accounts receivable $ 5,700 Increase in inventory 11,700 Decrease in prepaid rent 9,800 Increase in operating expenses payable 5,900...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2018 ($ in 000s) Revenues and gains: Sales $ 740 Gain on sale of buildings 12 $ 752 Expenses and loss: Cost of goods sold $ 270 Salaries 114 Insurance 34 Depreciation 117 Interest expense 44 Loss on sale of machinery 11 590 Income before tax 162 Income tax expense 81 Net income $ 81 PARNELL COMPANY Selected Accounts...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2018 ($ in 000s) Revenues and gains: Sales $ 700 Gain on sale of buildings 10 $ 710 Expenses and loss: Cost of goods sold $ 250 Salaries 110 Insurance 30 Depreciation 113 Interest expense 40 Loss on sale of machinery 13 556 Income before tax 154 Income tax expense 77 Net income $ 77 PARNELL COMPANY Selected Accounts...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For...
Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2018 ($ in 000s) Revenues and gains: Sales $ 780 Gain on sale of buildings 11 $ 791 Expenses and loss: Cost of goods sold $ 290 Salaries 118 Insurance 38 Depreciation 121 Interest expense 48 Loss on sale of machinery 12 627 Income before tax 164 Income tax expense 82 Net income $ 82 PARNELL COMPANY Selected Accounts...
Portions of the financial statements for Peach Computer are provided below. PEACH COMPUTER Income Statement For...
Portions of the financial statements for Peach Computer are provided below. PEACH COMPUTER Income Statement For the year ended December 31, 2021 Net sales $ 2,050,000 Expenses: Cost of goods sold $ 1,150,000 Operating expenses 660,000 Depreciation expense 60,000 Income tax expense 50,000 Total expenses 1,920,000 Net income $ 130,000 PEACH COMPUTER Selected Balance Sheet Data December 31 2021 2020 Increase (I) or Decrease (D) Cash $ 112,000 $ 90,000 $ 22,000 (I) Accounts receivable 46,000 54,000 8,000 (D) Inventory...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT