Please create Unadjusted Trial Balance according to the Excel file I provided.
1 attachments
Slide 1 of 1
attachment_1
attachment_1
UNFORMATTED ATTACHMENT PREVIEW
ASL AIRLINES HUNGARY Balance Sheet All numbers in thousands (Euros) Period Ending 12/31/2018 12/31/2017 Cash And Cash Equivalents 1.854.000 1.495.000 Short Term Investments 1.835.000 1.778.000 568.000 662.000 Numbers in USD 12/31/2018 Current Assets Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property, plant and equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets $2.123.757 $2.101.993 $650.644 $528.076 $49.257 $5.759.574 461.000 43.000 5.028.000 18.750.000 970.000 400.000 1.095.000 26.243.000 420.000 112.000 4.815.000 17.620.000 970.000 413.000 1.292.000 25.110.000 1.416.000 523.000 4.134.000 7.905.000 2.137.000 5.702.000 646000 16.390.000 1.320.000 349.000 3.495.000 6.863.000 3.341.000 5.265.000 15.469.000 $20.866.298 808.000 15.967.000 -8.432.000 1.510.000 20.000 9.853.000 8.483.000 808.000 13.832.000 -6.450.000 1.451.000 12.000 9.641.000 8.258.000 $1.124.736 $18.089.174 ($11.737.344) $2.101.920 $27.840 $13.715.376 $11.808.336 $26.100.000 $1.350.240 $556.800 $1.524.240 $35.290.854 Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities $1.622.028 $599.097 $4.735.497 $9.055.178 $2.974.704 $7.937.184 $899.232 Stockholders’ Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total stockholders’ equity Net Tangible Assets Total Liabilities and Shareholder Equity 26.243.000 25.110.000 $34.581.674 Numbers in USD 12/31/2017 $1.712.523 $2.036.699 $758.321 $481.110 $128.296 $5.515.583 $24.527.040 $1.350.240 $574.896 $1.798.464 $33.766.223 $1.512.060 $399.780 $4.003.523 $7.861.567 $4.650.672 $7.328.880 $0 $19.841.119 $1.124.736 $15.670.411 ($8.978.400) $2.019.792 $16.704 $13.420.272 $11.495.136 The functional currency is the Hungarian Forint The XE Currency Converter is the source of the exchange rates Year-end rate (12/31/2018) Year-end rate 10 years ago (12/31/2008) Average year-end rate for Five years 12-month average EUR/US DOLLARS 1,1455 1,392 1,13291 1,1786 All the workings are in the next excel sheet (Income statement ). $33.261.391 ASL AIRLINES HUNGARY Income Statement All numbers in thousands (Euros) Rate Revenue 12/31/2018 12/31/2017 Total Revenue 21.965.000 21.146.000 Cost of Revenue Gross Profit 14.881.000 7.084.000 14.028.000 7.118.000 215.000 2.501.000 18.798.000 3.167.000 238.000 2.329.000 17.792.000 3.354.000 -3.000 3.167.000 -93.000 3.164.000 699.000 2.465.000 -89.000 3.354.000 -65.000 3.265.000 -92.000 3.357.000 Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares – – – 2.465.000 – 2.465.000 3.357.000 – 3.357.000 1,1786 The functional currency is the US DOLLAR The XE Currency Converter is the source of the exchange rates EUR/USD All numbers in thousands USD 12/31/2018 $25.888.132 $17.538.871 $8.349.261 Year-end rate (12/31/2018) Year-end rate 10 years ago 12/31/2017 (12/31/2008) Average year-end rate for Five $24.922.852 years $16.533.518 12-month average $8.389.334 $253.401 $280.509 $2.947.699 $22.155.479 $3.732.653 $2.744.979 $20.969.799 $3.953.052 -$3.536 $3.732.653 -$109.611 $3.729.117 $823.847 -$104.896 $3.953.052 -$76.610 $3.848.156 -$108.432 $2.905.270 $3.956.588 $2.905.270 $3.956.588 $2.905.270 $3.956.588 1,1455 1,392 1,13291 1,1786 Five year computation End year 12/31/2014 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12 month computations (last ve year computation date of each month) Exchange rate 1/31/2018 1,2429 1,2110 1,0867 1,0523 1,2000 1,1146 2/28/2018 3/31/2018 4/30/2018 5/31/2018 6/30/2018 7/31/2018 8/31/2018 9/30/2018 10/31/2018 11/30/2018 12/31/2018 1,2211 1,2325 1,2076 1,1675 1,1691 1,1705 1,1599 1,1611 1,1334 1,1322 1,1455 Total Assets Total Liabilities Equity Retained Earnings Translation adjustment Line 12/31/2017 12/31/2018 $35.290.854 $33.766.223 $20.866.298 $19.841.119 $13.715.376 $13.420.272 $18.089.174 $15.670.411 ($17.379.994) ($15.165.579) $1.524.631 $1.025.179 $295.104 $2.418.763 The US Dollar, the functional currency, appreciated in value against the Euro, the secondary currency, and this resulted in a gain in the foreign exchange.
Purchase answer to see full attachment
Tags: Financial Management Budgeting Financial Statements Trial Balance investment strategy