Module ProjectProject InstructionPurpose of this ProjectYou will gain the following skills from the successful completion 5408

BA 6000 Business Foundations

Question.5408 - Module 4 ProjectProject InstructionPurpose of this ProjectYou will gain the following skills from the successful completion of this project:FinanceComplete ProForma Financial Statements based on given assumptionsForecast Free Cash FlowsCalculate Weighted Average Cost of Capital (WACC)Calculated Discounted Cash FlowsCalculate Net Present ValueCompare offers by calculating PV of different payment termsExcelAuto FillNPV functionPV functionInstructionsUse the Excel file and follow along with the Project Walk Through video to complete the project. Reference the Frequently Asked Questions file as needed. Submit the completed project as an excel file using canvas.Module 4 Project.xlsxDownload Module 4 Project.xlsxFAQ's for Project 4.pdf

Answer Below:

Module xxxxxxx Instructions xxx RubricIntroductionAqua xxx Gear xxx now xxxx in xxxxxxxx for xxxxx and xxxxxx is xxxxx to xxxx her xxxxxxx and xxxxxx To xx so xxx needs xx determine xx appropriate xxxxx for xxx company xxx compare xxxxxx Using xxx provided xxxxxxxxx statements xxxx Summer xxxxxx a xxxxxxxxxx Cash xxxx model xx determine xxx target xxxx price xxx Present xxxxx analysis xx compare xxxxxx Step xxx the xxxxxxxxxxx ProForma xxxxxxxxxxx to xxxx in xxx missing xxxxxxxxxxx projections xxxxxxxxxx Use xxx Balance xxxxx data xxxxxxxx to xxxx in xxx highlighted xxxx Cash xxxx Calculation xxxxx PointsStep xxx the xxxxxxx year xxxxxxxxxxx provided xx the xxxxxxx sheet xx complete xxx Weighted xxxxxxx Cost xx Capital xxxxxxxxxxx to xx used xx the xxxxxxxx rate xx future xxxx flows xxxxxxxxxx Complete xxx Discounted xxxx Flow xxxxx PointsCalculate xxx initial xxx compound xxxxxxxx rates xxx each xx the xxxxx projected xxxxxxxx each xxxxx projected xxxx flow xx the xxxxxxxxxxxxx discount xxxx to xxxxxxxxx each xxxxx NPV xxx the xxxxx function xx excel xx compare xx the xxxxxxx calculated xxxxxx has xxxxxxxx different xxxxxx to xxxxxxxx Aqua xxx Gear xxx first xxxxx is x single xx front xxxxxxx that xxx buyer xxxx finance xxxxxxx a xxxx The xxxxx two xxxxxx requested xxxxxx to xxxxxxxxxxxxxxx their xxxxxxxx The xxxxxxx payments xxx terms xxx provided xxx Aqua xxx Gears' xxxx is xxxx as xxx interest xxxx Step xxx the xx function xxxx the xxxxxxxxxxx provided xx determine xxx Present xxxxx of xxxx of xxx last xxx offers xxxxxxxxxxxxxx which xxxxx has xxx highest xx Step xxxxx a xxxxx paragraph xxxxxxxxxx what xxx learned xx this xxxxxx and xx Project xxxxxxxx the xxxxx year xx sales xx the xxxxx year xx sales xx the xxxxx year xx sales xx the xxxxx year xx sales x Revenues xxxxxxxx at x rate xx each xxxx The xxxx of xxxxx Sold xxxxxxxx The xxxxxxxxxxx and xxxxxxxxx budget xx Revenues xxxxxxxx at x rate xx each xxxx The xxxx of xxxxx Sold xxxxxxxx The xxxxxxxxxxx and xxxxxxxxx budget xx - xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxxxxx insurance xx a xxxx rate xx Licensing xxx Registration xx a xxxx rate xx Office xxxxxxxx average xx sales xxxxxxxx increase xx a xxxx of xxxx year xxx Cost xx Goods xxxx averages xxx advertising xxx promotion xxxxxx is xxxxxxxx increase xx a xxxx of xxxx year xxx Cost xx Goods xxxx averages xxx advertising xxx promotion xxxxxx is xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxxxx income xxx is xx prior xxxx Net xxxxxxxxxxxxx Taxes xxx of xxxxx Sales xxx is xx sales xxxxxxxx expense xxxxxxxx of xxxxx Software xxxxxxxx increase xxxx year xxx owner xxxxx a x salary xx is xxxxxxx that xxx buyer xxxx employ xxxxxxx for xxx same xxxx The xxxx other xxxxxxxx is xxxx time xxx paid xxxxxx at xx but xxxxx an xxx of xxxx bonus xxxx increases xxx total xxxxxx earning xx of xxxxx The xxxxxxx hosting xxx maintenance xx under x year xxxxxx contract xxxx an xx company xxxx began xx The xxxxx will xxxx increase xx for x new xxxx contact xx the xxxxx years xxxxxxxxx Income xx deposited xxxx the xxxxx Market xxxxxxx each xxxx Annual xxxxxxxx income xx of xxx prior xxxx ending xxxxxxx in xxx Money xxxxxx account xxxxxx Dividends xxxxxxxx money xxxxxx account xxxxxxx each xxxx The xxx of xxxx cash xxxxxxx is xxxxxxx to xx the xxxxx operating xxxxxxxx and xxx remainder xx taken xx distributions xx the xxxxx Ending xxxxxxxxx is xxxx at xx prior xxxx cost xx goods xxxx Aqua xxx Gear xxxx on x loan xx a xxxxxxxx rate xx Jan xx purchase x business xxxxx The xxxxx is xxxxxxxxxxx using xxx Straight xxxx method xxxx the xxxxxx of xxxxx Income xxxxxxxxxxxxxxx Actual xx FY xxxxxxxx DataFY xx FY xxxxx Total xxxxxx Cost xx Goods xxxx Gross xxxxxx ExpensesAdvertising xxxxxxxxx Interest xxxxxxx Licensing xxxxxxxxxxxx Office xxxxxxxx Shipping xxxxxxx Software xxxxxxxxxxxxxx Income xxx Payroll xxx Sales xxx Wages xxxxxxx Total xxxxxxxx Net xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx Income- x - x - xxx Income xxxxxx StatementIncome xxxxxx FY xx ProForma xxxxxx FY xx Sales xxxxx Income xxxx of xxxxx Sold xxxxx Profit xxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx Expense xxxxxxxxx Registration xxxxxx Supplies xxxxxxxx Expense xxxxxxxx TaxesCorporate xxxxxx Tax xxxxxxx Tax xxxxx Tax xxxxx Website xxxxx Expenses xxx Operating xxxxxx Other xxxxxxxxxxxxxx Income xxxxx ExpensesDepreciation xxx Other xxxxxxx - x - x Net xxxxxx Step xxxxxxxxxx PointsIncome xxxxxxxxxxxxxxx Actual xx FY xxxxxxxx DataFY xx FY xxxxx Total xxxxxx Cost xx Goods xxxx Gross xxxxxx ExpensesAdvertising xxxxxxxxx Interest xxxxxxx Licensing xxxxxxxxxxxx Office xxxxxxxx Shipping xxxxxxx Software xxxxxxxxxxxxxx Income xxx Payroll xxx Sales xxx Wages xxxxxxx Total xxxxxxxx Net xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx Income- x - x - xxx Income xxxxxx StatementIncome xxxxxx FY xx ProForma xxxxxx FY xx Sales xxxxx Income xxxx of xxxxx Sold xxxxx Profit xxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx Expense xxxxxxxxx Registration xxxxxx Supplies xxxxxxxx Expense xxxxxxxx TaxesCorporate xxxxxx Tax xxxxxxx Tax xxxxx Tax xxxxx Website xxxxx Expenses xxx Operating xxxxxx Other xxxxxxxxxxxxxx Income xxxxx ExpensesDepreciation xxx Other xxxxxxx - x - x Net xxxxxx Aqua xxx Gear xxxxxxxxxxx Structure xx of xxxxxxxxxx Amount xx Capital xxxxxxxxx Cost xx Capital xxx of xxx Weighted xxxxxxx Cost xx Capital xxxx PointsDiscounted xxxx Flow xxxxxxx FY xx FY xx TotalFree xxxx Flow xx FirmCompounded xxxxxxxx Rate x Present xxxxx of xxxx Flow xxx Present xxxxx Step xxxxxxxxxxxxxx Offers xxxxxx Amount xx Each xxxxxxx Number xx Payments xxxx how xxxx years xxxxxxxx Rate xxxxx Payments xxxxxxxx Effective xxxxxxxx Price xxxxxxx Value xxxxx offer xxx the xxxxxxx PV xxxx Points xx Module x deepened xx understanding xx the xxxx value xx money xxxxx emphasizes xxx importance xx evaluating xxx present xxx future xxxxx of xxxx flows xx decision-making x explored xxxxxxx methods xx raising xxxxxxx such xx equity xxx debt xxxxxxxxx and xxxxxxx how xx calculate xxxxx associated xxxxx to xxxxxxxx a xxxxxx capital xxxxxxxxx It xxxxxxx expanded xx capabilities xx applying xxxxxxxxx Excel xx financial xxxxxxxx for xxxxxxx the xxxxxxxxxxx and xxxxxxxxxx of xxx Present xxxxx in xxxxxxxxx projects x thereby xxxxxxxxxxx acquired xxx skills xxxxxx for xxxx flow xxxxxxxx being xxxx to xxxxxxxxx the xxxx opportunities xxxx an xxxxxxxxxx could xxxxxxx In xxxxxx I xxxxxxxx my xxxxxxxxxxxxx of xxx time xxxxx of xxxxx which xxxxxxxxxx the xxxxxxxxxx of xxxxxxxxxx the xxxxxxx and xxxxxx value xx cash xxxxx in xxxxxxxxxxxxxxx I xxxxxxxx various xxxxxxx of xxxxxxx capital xxxx as xxxxxx and xxxx financing xxx learned xxx to xxxxxxxxx their xxxxxxxxxx costs xx optimize x firm's xxxxxxx structure xx further xxxxxxxx my xxxxxxxxxxxx in xxxxxxxx Microsoft xxxxx in xxxxxxxxx analysis xxx example xxx computation xxx comparison xx Net xxxxxxx Value xx different xxxxxxxx I xxxxxxx practically xxxxxxxx the xxxxxx needed xxx cash xxxx analysis xxxxx able xx highlight xxx best xxxxxxxxxxxxx that xx investment xxxxx realize xxxxx a xxxxx paragraph xxxxxxxxxx what xxx learned xx this xxxxxx and xx Project xx Module x deepened xx understanding xx the xxxx value xx money xxxxx emphasizes xxx importance xx evaluating xxx present xxx future xxxxx of xxxx flows xx decision-making x explored xxxxxxx methods xx raising xxxxxxx such xx equity xxx debt xxxxxxxxx and xxxxxxx how xx calculate xxxxx associated xxxxx to xxxxxxxx a xxxxxx capital xxxxxxxxx It xxxxxxx expanded xx capabilities xx applying xxxxxxxxx Excel xx financial xxxxxxxx for xxxxxxx the xxxxxxxxxxx and xxxxxxxxxx of xxx Present xxxxx in xxxxxxxxx projects x thereby xxxxxxxxxxx acquired xxx skills xxxxxx for xxxx flow xxxxxxxx being xxxx to xxxxxxxxx the xxxx opportunities xxxx an xxxxxxxxxx could xxxxxxx In xxxxxx I xxxxxxxx my xxxxxxxxxxxxx of xxx time xxxxx of xxxxx which xxxxxxxxxx the xxxxxxxxxx of xxxxxxxxxx the xxxxxxx and xxxxxx value xx cash xxxxx in xxxxxxxxxxxxxxx I xxxxxxxx various xxxxxxx of xxxxxxx capital xxxx as xxxxxx and xxxx financing xxx learned xxx to xxxxxxxxx their xxxxxxxxxx costs xx optimize x firm's xxxxxxx structure xx further xxxxxxxx my xxxxxxxxxxxx in xxxxxxxx Microsoft xxxxx in xxxxxxxxx analysis xxx example xxx computation xxx comparison xx Net xxxxxxx Value xx different xxxxxxxx I xxxxxxx practically xxxxxxxx the xxxxxx needed xxx cash xxxx analysis xxxxx able xx highlight xxx best xxxxxxxxxxxxx that xx investment xxxxx realize xxxx PointsFree xxxx Flow xxxxxxxxxxxxxx back xxxxxxxx deductions xxxxxxxxxxxx ExpenseChanges xx Working xxxxxxx Actual xxxxxxxx DataChange xx Inventory xxxx Payments xxxx Cash xxxx to xxxx of xxx prior xxxx of xxxxx of xxx prior xxxx of xxxxx of xxx prior xxxx of xxxxx of xxx prior xxxx of xxxxx - xxxxxxxx increase xx a xxxx of xxxx year xxx Cost xx Goods xxxx averages xxx advertising xxx promotion xxxxxx is xxxxxxxx increase xx a xxxx of xxxx year xxx Cost xx Goods xxxx averages xxx advertising xxx promotion xxxxxx is x Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Commercial xxxxxxxxx is x flat xxxx of xxxxxxxxx and xxxxxxxxxxxx is x flat xxxx of xxxxxx Supplies xxxxxxx of xxxxx Revenues xxxxxxxx at x rate xx each xxxx The xxxx of xxxxx Sold xxxxxxxx The xxxxxxxxxxx and xxxxxxxxx budget xx Revenues xxxxxxxx at x rate xx each xxxx The xxxx of xxxxx Sold xxxxxxxx The xxxxxxxxxxx and xxxxxxxxx budget xx Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Corporate xxxxxx tax xx of xxxxx year xxx IncomePayroll xxxxx are xx wages xxxxx Tax xx of xxxxx Shipping xxxxxxx averages xx COGS xxxxxxxx expenses xxxxxxxx each xxxx The xxxxx takes x K xxxxxx It xx assumed xxxx the xxxxx will xxxxxx manager xxx the xxxx rate xxx only xxxxx employee xx part xxxx and xxxx hourly xx hr xxx given xx end xx year xxxxx that xxxxxxxxx his xxxxx annual xxxxxxx to xx sales xxx website xxxxxxx and xxxxxxxxxxx is xxxxx a xxxx annual xxxxxxxx with xx IT xxxxxxx that xxxxx in xxx price xxxx then xxxxxxxx to xxx a xxx year xxxxxxx of xxx prior xxxxx Operating xxxxxx is xxxxxxxxx into xxx Money xxxxxx Account xxxx year xxxxxx Dividend xxxxxx is xx the xxxxx year xxxxxx balance xx the xxxxx Market xxxxxxx Annual xxxxxxxxx increase xxxxx market xxxxxxx balance xxxx year xxx end xx year xxxx account xx reduced xx of xxx years xxxxxxxxx expenses xxx the xxxxxxxxx is xxxxx as xxxxxxxxxxxxx to xxx owner xxxxxx inventory xx kept xx of xxxxx year xxxx of xxxxx sold xxxx Fun xxxx took xx a xxxx at x interest xxxx in xxx to xxxxxxxx a xxxxxxxx truck xxx truck xx depreciated xxxxx the xxxxxxxx Line xxxxxx over xxx course xx years xxxxxx StatementIncomeSales xxxxx IncomeCost xx Goods xxxx Gross xxxxxxxxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx ExpenseLicensing xxxxxxxxxxxx Office xxxxxxxxxxxxxxxx Expense xxxxxxxxxxxxxxxxxxxxxx Income xxx Payroll xxxxxxxx TaxWages xxxxxxxxxxxx ExpensesNet xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx IncomeNet xxxxxxxxxxxxxxxxxxxx Data xx FY xx FY xx - x - x - xxxxxx StatementIncomeSales xxxxx IncomeCost xx Goods xxxx Gross xxxxxxxxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx ExpenseLicensing xxxxxxxxxxxx Office xxxxxxxxxxxxxxxx Expense xxxxxxxxxxxxxxxxxxxxxx Income xxx Payroll xxxxxxxx TaxWages xxxxxxxxxxxx ExpensesNet xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx IncomeNet xxxxxxxxxxxxxxxxxxxx Data xx FY xx FY xx - x - x - xxxx PointsStep xxxxxxxxxxxx StatementIncomeSales xxxxx IncomeCost xx Goods xxxx Gross xxxxxxxxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx ExpenseLicensing xxxxxxxxxxxx Office xxxxxxxxxxxxxxxx Expense xxxxxxxxxxxxxxxxxxxxxx Income xxx Payroll xxxxxxxx TaxWages xxxxxxxxxxxx ExpensesNet xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx IncomeNet xxxxxxxxxxxxxxxxxxxx Data xx FY xx FY xx - x - x - xxxxxx StatementIncomeSales xxxxx IncomeCost xx Goods xxxx Gross xxxxxxxxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx ExpenseLicensing xxxxxxxxxxxx Office xxxxxxxxxxxxxxxx Expense xxxxxxxxxxxxxxxxxxxxxx Income xxx Payroll xxxxxxxx TaxWages xxxxxxxxxxxx ExpensesNet xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx IncomeNet xxxxxxxxxxxxxxxxxxxx Data xx FY xx FY xx - x - x - xxxx Fun xxxx WACCCapital xxxxxxxxx as xx DebtEquity xxxxxx - xx Capital xxxxxxxxx Cost xx Capital xxx of xxx Weighted xxxxxxx Cost xx Capital xxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxx - xxxx Points xxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxx Points xxxxx a xxxxx paragraph xxxxxxxxxx what xxx learned xx this xxxxxx and xx Project xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxx Points xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxxxx in xxxxxxxxx Debt xxxxxxxx - x - x Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Revenues xxxxxxxx at x rate xx each xxxx The xxxx of xxxxx Sold xxxxxxxx Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx The xxxxxxxxxxx and xxxxxxxxx budget xx of xxx prior xxxx of xxxxx Commercial xxxxxxxxx is x flat xxxx of xxxxxxxxx and xxxxxxxxxxxx is x flat xxxx of xxxxxx Supplies xxxxxxx of xxxxx Corporate xxxxxx tax xx of xxxxx year xxx IncomePayroll xxxxx are xx wages xxxxx Tax xx of xxxxx Shipping xxxxxxx averages xx COGS xxxxxxxx expenses xxxxxxxx each xxxx The xxxxx takes x K xxxxxx It xx assumed xxxx the xxxxx will xxxxxx manager xxx the xxxx rate xxx only xxxxx employee xx part xxxx and xxxx hourly xx hr xxx given xx end xx year xxxxx that xxxxxxxxx his xxxxx annual xxxxxxx to xx sales xxx website xxxxxxx and xxxxxxxxxxx is xxxxx a xxxx annual xxxxxxxx with xx IT xxxxxxx that xxxxx in xxx price xxxx then xxxxxxxx to xxx a xxx year xxxxxxx of xxx prior xxxxx Operating xxxxxx is xxxxxxxxx into xxx Money xxxxxx Account xxxx year xxxxxx Dividend xxxxxx is xx the xxxxx year xxxxxx balance xx the xxxxx Market xxxxxxx Annual xxxxxxxxx increase xxxxx market xxxxxxx balance xxxx year xxx end xx year xxxx account xx reduced xx of xxx years xxxxxxxxx expenses xxx the xxxxxxxxx is xxxxx as xxxxxxxxxxxxx to xxx owner xxxxxx inventory xx kept xx of xxxxx year xxxx of xxxxx sold xxxx Fun xxxx took xx a xxxx at x interest xxxx in xxx to xxxxxxxx a xxxxxxxx truck xxx truck xx depreciated xxxxx the xxxxxxxx Line xxxxxx over xxx course xx years xxxxxx StatementIncome xxxxxx FY xx ProForma xxxxxx FY xx Sales xxxxx IncomeCost xx Goods xxxxxxxxx ProfitExpensesAdvertisingInsuranceInterest xxxxxxxxxxxxxxxx RegistrationOffice xxxxxxxx Shipping xxxxxxx Software xxxxxxxxxxxxxx Income xxx Payroll xxx Sales xxx Wages xxxxxxx Total xxxxxxxxxxx Operating xxxxxxxxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx Income- x - x - xxx Income xxxxxx StatementIncome xxxxxx FY xx ProForma xxxxxx FY xx Sales xxxxx IncomeCost xx Goods xxxxxxxxx ProfitExpensesAdvertisingInsuranceInterest xxxxxxxxxxxxxxxx RegistrationOffice xxxxxxxx Shipping xxxxxxx Software xxxxxxxxxxxxxx Income xxx Payroll xxx Sales xxx Wages xxxxxxx Total xxxxxxxxxxx Operating xxxxxxxxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx Income- x - x - xxx Income xxxx PointsStep xxxxxxxxxxxx StatementIncome xxxxxx FY xx ProForma xxxxxx FY xx Sales xxxxx IncomeCost xx Goods xxxxxxxxx ProfitExpensesAdvertisingInsuranceInterest xxxxxxxxxxxxxxxx RegistrationOffice xxxxxxxx Shipping xxxxxxx Software xxxxxxxxxxxxxx Income xxx Payroll xxx Sales xxx Wages xxxxxxx Total xxxxxxxxxxx Operating xxxxxxxxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx Income- x - x - xxx Income xxxxxx StatementIncome xxxxxx FY xx ProForma xxxxxx FY xx Sales xxxxx IncomeCost xx Goods xxxxxxxxx ProfitExpensesAdvertisingInsuranceInterest xxxxxxxxxxxxxxxx RegistrationOffice xxxxxxxx Shipping xxxxxxx Software xxxxxxxxxxxxxx Income xxx Payroll xxx Sales xxx Wages xxxxxxx Total xxxxxxxxxxx Operating xxxxxxxxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx Income- x - x - xxx Income xxxx Fun xxxx WACCCapital xxxxxxxxx as xx DebtEquity xxxxxx of xxxxxxx Structure xxxx of xxxxxxx net xx tax xxxxxxxx Average xxxx of xxxxxxx Aqua xxx Gear xxxxxxxxxxx Structure xx of xxxxxxxxxx Amount xx Capital xxxxxxxxx Cost xx Capital xxx of xxx Weighted xxxxxxx Cost xx Capital xxxx Fun xxxx WACCCapital xxxxxxxxx as xx DebtEquity xxxxxx of xxxxxxx Structure xxxx of xxxxxxx net xx tax xxxxxxxx Average xxxx of xxxxxxx Aqua xxx Gear xxxxxxxxxxx Structure xx of xxxxxxxxxx Amount xx Capital xxxxxxxxx Cost xx Capital xxx of xxx Weighted xxxxxxx Cost xx Capital x Step xxxxxx Discounted xxxx Flow xxxxxxx FY xx FY xx TotalFree xxxx Flow xx Firm- xxxxxxxxxx Discount xxxx Present xxxxx of xxxx Flow- xxx Present xxxxxx Step xxxxxx Evaluate xxxxxxxxxxxx Amount xx Each xxxxxxx Number xx Payments xxxx how xxxx years xxxxxxxx Rate xxxxx Payments xxxxxxxx Effective xxxxxxxx Price xxxxxxx Value xxxxx offer xxx the xxxxxxx PV xxxx the xxxxx numberEvaluate xxxxxxxxxxxx Amount xx Each xxxxxxx Number xx Payments xxxx how xxxx years xxxxxxxx Rate xxxxx Payments xxxxxxxx Effective xxxxxxxx Price xxxxxxx Value xxxxx offer xxx the xxxxxxx PV xxxx the xxxxx number xxxxxxxx OffersOffers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxxxxxx OffersOffers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxx - xxxx Points xxxxx a xxxxx paragraph xxxxxxxxxx what xxx learned xx this xxxxxx and xx Project xxxx PointsFree xxxx Flow xxxxxxxxxxxxxx back xxxxxxxx deductionsActualProForma xxxxxxxxxxxxxxxx Expense xxxxxxx in xxxxxxx CapitalChange xx Inventory x - x - x Debt xxxxxxxx - x Free xxxx Flow xx Firm x - xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxxxxxxx increase xx a xxxx of xxxx year xxx Cost xx Goods xxxx averages xxxxxxx SheetActualProForma xxxxxxxxxx FY xx FY xx FY xxxx Money xxxxxx Account xxxxxxxxx Current xxxxxx Fixed xxxxxx Accumulated xxxxxxxxxxxx Total xxxxx Assets x - x -Total xxxxxx LiabilitiesLong xxxx Liabilities xxxxx Liabilites x - x -EquityOwners xxxxxx Retained xxxxxxxx Total xxxxxx Total xxxxxxxxxxx and xxxxxx Balance xxxxxxxxxxxxxxxxxxx DataAssets xx FY xx FY xx Cash xxxxx Market xxxxxxx Inventory xxxxxxx Assets xxxxx Assets xxxxxxxxxxx Depreciation xxxxx Fixed xxxxxx - x - xxxxxx Assets xxxxxxxxxxxxxxx Term xxxxxxxxxxx Total xxxxxxxxxx - x - xxxxxxxxxxxxx Equity xxxxxxxx Earnings xxxxx Equity xxxxx Liabilities xxx Equity xxx advertising xxx promotion xxxxxx is xx the xxxxx year xx sales xxxxxxxxxx insurance xx a xxxx rate xx Licensing xxx Registration xx a xxxx rate xx Office xxxxxxxx average xx sales xxxxxxxxx income xxx is xx prior xxxx Net xxxxxx Payroll xxxxx are xx wages xxxxx Tax xx of xxxxx Shipping xxxxxxx averages xx COGS xxxxxxxx expenses xxxxxxxx each xxxx The xxxxx takes x K xxxxxx It xx assumed xxxx the xxxxx will xxxxxx manager xxx the xxxx rate xxx only xxxxx employee xx part xxxx and xxxx hourly xx hr xxx given xx end xx year xxxxx that xxxxxxxxx his xxxxx annual xxxxxxx to xx sales xxx website xxxxxxx and xxxxxxxxxxx is xxxxx a xxxx annual xxxxxxxx with xx IT xxxxxxx that xxxxx in xxx price xxxx then xxxxxxxx to xxx a xxx year xxxxxxx of xxx prior xxxxx Operating xxxxxx is xxxxxxxxx into xxx Money xxxxxx Account xxxx year xxxxxx Dividend xxxxxx is xx the xxxxx year xxxxxx balance xx the xxxxx Market xxxxxxx Annual xxxxxxxxx increase xxxxx market xxxxxxx balance xxxx year xxx end xx year xxxx account xx reduced xx of xxx years xxxxxxxxx expenses xxx the xxxxxxxxx is xxxxx as xxxxxxxxxxxxx to xxx owner xxxxxx inventory xx kept xx of xxxxx year xxxx of xxxxx sold xxxx Fun xxxx took xx a xxxx at x interest xxxx in xxx to xxxxxxxx a xxxxxxxx truck xxx truck xx depreciated xxxxx the xxxxxxxx Line xxxxxx over xxx course xx years xxxxxx StatementIncomeSales xxxxx IncomeCost xx Goods xxxx Gross xxxxxxxxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx ExpenseLicensing xxxxxxxxxxxx Office xxxxxxxxxxxxxxxx Expense xxxxxxxxxxxxxxxxxxxxxx Income xxx Payroll xxxxxxxx Tax xxxxx WebsiteTotal xxxxxxxxxxx Operating xxxxxx Other xxxxxxxxxxxxxx Income xxxxx ExpensesDepreciation xxx Other xxxxxxxxx IncomeActualProForma xxxx FY xx FY xx FY x - x - x Income xxxxxxxxxxxxxxxxxxxx Total xxxxxxxxxx of xxxxx Sold xxxxx ProfitExpensesAdvertising xxxxxxxxx Interest xxxxxxxxxxxxxxxx Registration xxxxxx SuppliesShipping xxxxxxx SoftwareTaxesCorporate xxxxxx Tax xxxxxxx TaxSales xxx Wages xxxxxxxxxxxx ExpensesNet xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx IncomeNet xxxxxxxxxxxxxxxxxxxx Data xx FY xx FY xx - x - x - xxxx PointsStep xxxxxxxxxxxx StatementIncomeSales xxxxx IncomeCost xx Goods xxxx Gross xxxxxxxxxxxxxxxxxxxxxxxxx Insurance xxxxxxxx ExpenseLicensing xxxxxxxxxxxx Office xxxxxxxxxxxxxxxx Expense xxxxxxxxxxxxxxxxxxxxxx Income xxx Payroll xxxxxxxx Tax xxxxx WebsiteTotal xxxxxxxxxxx Operating xxxxxx Other xxxxxxxxxxxxxx Income xxxxx ExpensesDepreciation xxx Other xxxxxxxxx IncomeActualProForma xxxx FY xx FY xx FY x - x - x Income xxxxxxxxxxxxxxxxxxxx Total xxxxxxxxxx of xxxxx Sold xxxxx ProfitExpensesAdvertising xxxxxxxxx Interest xxxxxxxxxxxxxxxx Registration xxxxxx SuppliesShipping xxxxxxx SoftwareTaxesCorporate xxxxxx Tax xxxxxxx TaxSales xxx Wages xxxxxxxxxxxx ExpensesNet xxxxxxxxx Income xxxxx IncomeDividend xxxxxx Other xxxxxxxxxxxxxxxxxxxx Net xxxxx IncomeNet xxxxxxxxxxxxxxxxxxxx Data xx FY xx FY xx - x - x - xxxx Fun xxxx WACCCapital xxxxxxxxx as xx DebtEquity xxxxxx - xx Capital xxxxxxxxx Cost xx Capital xxx of xxx Weighted xxxxxxx Cost xx Capital xxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxx - xxxx Points xxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxxxxxxxx Cash xxxx ModelFY xx FY xx FY xxxxxxxxx Cash xxxx to xxxx Compounded xxxxxxxx Rate xxxxxxx Value xx Cash xxxx Net xxxxxxx Value xxxx PointsEvaluate xxxxxx Offers xxxxxx of xxxx Payment xxxxxx of xxxxxxxx Over xxx many xxxxx Interest xxxx Total xxxxxxxx Received xxxxxxxxx Purchase xxxxx Present xxxxx Which xxxxx has xxx highest xx Just xxx offer xxxxxxxxxx Points xxxxx a xxxxx paragraph xxxxxxxxxx what xxx learned xx this xxxxxx and xx Project xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxx Points xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxx Cash xxxx CalculationAdd xxxx non-cash xxxxxxxxxx Depreciation xxxxxxxxxxxxxx in xxxxxxx CapitalActualProForma xxxx -Free xxxx Flow xx Firm xxxxxx in xxxxxxxxx Debt xxxxxxxx - x