Problem $3-27$ Spreadsheet Problem: Spreading the Financial Statements $($LG$3-6)$Use the following financial statements for Lake of Egypt Marina, Incorporated,AssetsCurrent assets:Cash and marketable securitiesAccounts receivableInventoryTotalFixed assetsGross plant and equipmentother long $-$term assetsTotalTotal assetsNet sales $($all credit$)$Less: Cost of goods soldt and equipmentGross profitsLess: Other operating expensesLess: DepreciationLess: InterestEarnings before taxes $($EBT$)$Less: TaxesNet incomeLess: Preferred stock dividendsLess: Common stock dividendsAddition to retained earningsPer $($common$)$ share data:TotalEarnings per share $($EPS$)$Dividends per share $($DPS$)$Book value per share $($BVPS$)$Current assets:Earnings before interest and taxes $($EBIT$)$InventoryCash and marketable securitiesAccounts receivableFixxed assetsAssetsNet income available to common stockholdersGross plant and equipmentMarket value $($price$)$ per share $($MVPS$)$Less: DepreciationNet plant and equipmentTotalTotal assetsOther iong term assetsNet salesGross profi$2024$Less: Cost of goods soldLAKE OF EGYPT MARINA, INCORPORATEDBalance Sheet as of December $31,2824$ and $2823($in millions of dollars$)$Earnings before interest, taxes, depreciation, and amortization $($EBITDA$)$$ $55$$ $280$Less: Depreciation$18$e$ $265$Less: Interest$ $195$Earnings before taxesLess: TaxesS $22$eNet income$25$$ $5$ee$2024$Spread the balance sheets of Lake of Egypt Marina, Incorporated, for $2024$ and $2023.$Note: Input all amounts as posltlve values. Round your answers to $2$ declmal places.Less: Other operating expenses$2023$$ $4862920\mathrm{.}00\%$$ $192$Income Statement teMRLNA, INCORPORATEDfor YeaEndin$8$ December $31,2824$ and $2023($in millions dollars$)$Earnings before interest and taxes$22418424$$ $208$Liabilities and EquityCurrent liabilities:Accrued wages and taxesAccounts payableLAKE OF EGYPTNotes payableLong$-$tern debtTotalStockholders equity :Common stock and paid$-$in surplus $(24$ million sharesRetained earningsTotal$ $48$e Total liabilities and equityLAKE OF EGYPT MARINA, INCORPORATEDBalance Sheet as of December $31,2024$ and $202320230\mathrm{.}009\%$illion shares$)$Spread the Income statements of Lake of Egypt Marina, Incorporated, for $2024$ and $2023.$Note: Input all amounts as positlve values. Round your answers to $2$ declmal places.Curent liabilities:Accrued wage and taxesAccounts payableNotes payableTotalLiabilities and EquityLong$-$term debt:Stockholders' equity:Preferred stockEarnings before interest, taxes, depreciation, and amortizationCommon stock and paid in surplusTotalRetained earningsTotal liabilities and equityIncome Statement for Years Ending December $31,2024$ and $2023$LAKE OF EGYPT MARINA, INcORPORATED$20242024$$ $60$e$216$$ $384354$$ $32424$$ $3$ee$ $218$$ $2$$ $20824$$ $1842024$$ $8\mathrm{.}667$$ $1\mathrm{.}0$ee$ $13.$eee$ $15\mathrm{.}30$e$0\mathrm{.}00\%20232024$$ $13556$$ $51$$ $22023288$S $314$$ $400120$$ $2801626424$$ $24020$$ $22066$$ $154$$$2$$ $15224$$ $128$$ $6\mathrm{.}333$$ $1\mathrm{.}90$e$ $5\mathrm{.}333$$ $10\mathrm{.}9$ee$20230\mathrm{.}009\%2023$$ $364452$$ $132$$ $138$$$104$$ $13$e