Atlantic Aquatic Equipment Inc. Atlantic Aquatic Equipment Comparative Balance Sheets Vertical Analysis - Balance Sheets Current Year Prior Year Change Current Year Prior Year Cash               78,000.00                 86,400.00       (8,400.00) 14% 17% Account...

80.2K

Verified Solution

Question

Accounting

Atlantic Aquatic EquipmentInc.Atlantic AquaticEquipment
Comparative Balance SheetsVertical Analysis - Balance Sheets
Current YearPrior YearChangeCurrent YearPrior Year
Cash             78,000.00               86,400.00      (8,400.00)14%17%
Account Receivable          603,000.00             526,800.00      76,200.00U24%24%
Inventory       1,254,000.00          1,072,800.00   181,200.00U51%49%
Total Current Assets       1,935,000.00          1,686,000.0078%77%
Fixed Assets          790,500.00             736,500.00      54,000.00U32%33%
Less: Accumulated Depreciation          249,300.00             219,300.00      30,000.0010%10%
Net Fixed Assets          541,200.00             517,200.0022%23%
TOTAL ASSETS       2,476,200.00          2,203,200.00
Accounts Payable          262,800.00             218,400.00      44,400.00S11%10%
Notes Payable          337,500.00             300,000.00      37,500.00S14%14%
Accruals          210,000.00             204,000.00        6,000.00S8%9%
Total Current Liabilities          810,300.00             722,400.0033%33%
Long Term Debt          636,918.00             485,148.00   151,770.00S26%22%
Total Liabilities       1,447,218.00          1,207,548.0058%55%
Common Stock          690,000.00             690,000.00                   -  28%31%
Retained Earnings          338,982.00             305,652.00      33,330.00S14%14%
Total Equity       1,028,982.00             995,652.0042%45%
TOTAL LIABILITIES AND EQUITY       2,476,200.00          2,203,200.00
Atlantic Aquatic Equipment Inc.Atlantic Aquatic Equipment
Comparative Income StatementsVertical Analysis - Income Statements
Current YearPrior YearCurrent YearPrior Year
Sales       5,782,000.00          5,260,255.00
Cost of Goods Sold       4,875,000.00          4,296,000.00answeranswer
Gross Profit          907,000.00             964,255.00answeranswer
answeranswer
Selling, General and Admin Exp.          645,450.00             610,000.00answeranswer
Depreciation             30,000.00               28,350.00answeranswer
Operating Profit (EBIT)          231,550.00             325,905.00answeranswer
answeranswer
Interest Expense          114,000.00               93,750.00answeranswer
Earnings B4 Taxes          117,550.00             232,155.00answeranswer
answeranswer
Tax (@40%)             47,020.00               92,862.00answeranswer
NET INCOME             70,530.00             139,293.00answeranswer
Dividend Payment             37,200.00-
Atlantic Aquatic Equipment Inc.
Cash Flow Statement
Net Incomeansweranswer
Depreciation Expenseansweranswer
answeranswer
Changes in NWC:answeranswer
_________ in A/Ransweranswer
_________ in Inventoryansweranswer
_________ in A/Pansweranswer
_________ in N/Pansweranswer
_________ in Accrualsansweranswer
Net Cash Flow from Operationsansweranswerx
Purchased Equipmentansweranswer
Net Cash Flow from Investingansweranswer
_________ in LTDansweranswer
Paid CS Dividendansweranswer
Net Cash Flow from Financingansweranswer
Total Net Cash Flowansweranswer
Ratio AnalysisB/WB/W
LiquidityFormulaIndusty AverageCurrent YearPrior Yearthan Industrythan Prior Year
Current RatioCA/CL2.8answeransweransweranswer
Quick Ratio(CA-Inventory)/ CL1.1answeransweransweranswer
Asset Mgt Ratios (T/O)
Inventory T/OSales/Inventory7.2answeransweransweranswer
Fixed Asset T/ONet Sales/ Net Fixed Assets10.5answeransweransweranswer
Total Asset T/OSales/Total Assets2.6answeransweransweranswer
Debt (Leverage)
Debt RatioTotal Liab/ Total Assets50%58.4%54.8%MM
Financial LeverageTotal Assets/Equity                         0.02               2.41              2.21MM
Profitability Ratios
Gross Profit MarginGross Profit/Sales25.9%answeransweransweranswer
Operating Profit MarginOperating Profit/ Sales13.3%answeransweransweranswer
Net Profit MarginNet Profit/ Sales3.60%answeransweransweranswer
Return on AssetsNet Income/Total Assets9.4%answeransweransweranswer
Return on EquityNet Income/Total Equity18.8%answeransweransweranswer
DuPont AnalysisOperating EfficiencyAsset MgtFinancial LeverageReturn on Equity
(Profit Margin)(Total Asset T/O)(Debt)=
FORMULASNet IncomeSalesTotal Assets
SalesTotal AssetsEquity
Current Yearansweransweranswer#VALUE!
Prior Yearansweransweranswer#VALUE!
Industry Average                      3.60                         2.60               2.0118.8136

Answer & Explanation Solved by verified expert
3.9 Ratings (636 Votes)
The    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students