Answer http://www.transtutors.co


Question Description:

25

See Attached Files Document Preview: Loan PaymentProForma Balance SheetProForma Income StatementCash Flow BudgetOperating BudgetMonth1_Ending_Bal*Assumed – corporate tax rates are tiered based ontotal net profit. Reference IRS tax code for proper %.Total Current AssetsFixed AssetsLandAdvertisingBank service chargesBusiness insuranceTotal ExpensesQuarter 1Capital PurchasesOther Cash Out Flows:Cash Outflows (Expenses):Available Cash Balance Total Cash InflowsAccts. Rec. CollectionsBeginning Cash BalanceMonth 3DepreciationBuildings Plant & equipment Furniture & fixtures Accumulated DepreciationOther Long-term AssetsTestCurrent portion of long-term notesAccruals & other payablesTotal Current LiabilitiesLong-term LiabilitiesMortgageOther long-term liabilitiesTotal Long-term LiabilitiesSHAREHOLDERS’ EQUITYCapital stockDues and subscriptionsHealth insuranceInventoryLease paymentsLoan paymentsMonth 1Month 2Month 3TotalStartupOwner SalarySales taxSuppliesCashCost of SalesCost of SalesRevenueTaxes on Income (34%)*Total Start up Costs Interest RateTerm – No. of yearsAmount of LoanMonthly Payment3 MonthsInterest ExpenseMonthShort – TermLong – Term Principal PaymentInterest RateTerm – No. of yearsAmount of LoanMonthly PaymentMonthNET INCOMEUnanticipated Expenses/OtherLoan payments – Interest onlyOther: Monthly Operating ExpensesTelephone / UtilitiesTelephone / UtilitiesMiscellaneous/OtherMiscellaneous/OtherOwner SalaryPayroll (excluding owner)Operating BudgetStartup CostsCash Inflows:Revenue ReceiptsQuarter 1EXPENSESStartup CostsNet Income Before TaxesPro Forma Income StatementPro Forma Balance SheetGROSS PROFITTOTAL EXPENSESTotal Net Fixed AssetsTOTAL ASSETSLIABILITIESCurrent LiabilitiesAccounts payableRetained earningsTotal Shareholders’ EquityTOTAL LIABILITIES & EQUITY SubtotalPayroll taxesProfessional feesRentRepairs and maintenanceMonth 2Month 1Cash Flow BudgetRevenueOperating IncomeGross MarginBuilding ConstructionDecoratingDepositsFixtures and EquipmentInstallation of Fixtures and EquipmentLicenses and… Attachments: RH-Operating-….xls RH-Assignment….doc

Answer

25