Attachment # 00011053 - ProjectedFinancialStatementAnalysis.xlsx
ProjectedFinancialStatementAnalysis.xlsx (40.75 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
ResponseAdditional considerationsOneOneTwoTwoThreeThreeFourFourFiveSixSevenEightNineTenElevenTwelveQuarter Annual totalProperty InsuranceRatesRentRepair & maintenanceWaste removalWaterTotal Occupancy CostsOther ExpensesAdd an expense description hereTotal Other ExpensesTotal ExpensesMonth Net Profit / (Loss)Total Year to Date Net Profit / (Loss)Give careful thought to the headings.Profit and Loss StatementInstructionsGive careful thought to the headings.Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sales for each also separated).MonthIncomeSalesSale of goods/servicesSundry Income (e.g. Commission earned, frachise fees etc.)Etc.Total SalesLess Discounts/CommissionsSales Discounts givenSales Commissions paidTotal Discounts/ CommissionsTotal Net IncomeCost of SalesOpening StockStock PurchasedLess Closing StockTotal Cost of SalesGross ProfitExpensesGeneral & AdministrativeBank chargesCredit card commissionConsultant feesOffice SuppliesLicense feesBusiness insuranceTotal General & AdministrativeMarketing & PromotionalAdvertisingPromotion - GeneralPromotion - OtherTotal Marketing & PromotionalOperating ExpensesNewspapers & magazinesParking/Taxis/TollsEntertainment/MealsTravel/AccomodationLaundry/dry cleaningCleaning & cleaning productsSundry suppliesEquipment hireTotal Operating ExpensesMotor Vehicle ExpensesFuelVehicle service costsTyres & other replacement costsInsuranceRegistrationsTotal Motor Vehicle ExpensesWebsite ExpensesDomain name registrationHosting expensesetcTotal Website ExpensesEmployment ExpensesPermanentSalaries/WagesPAYESuperannuationOther - Employee BenefitsRecruitment costsTotal Perm. Employment ExpensesCasualTotal Casual Employment ExpensesWorkcover InsuranceTotal Employment ExpensesOccupancy CostsElectricity/GasTelephonesIdentify your cost structure. Is your business model cost-driven or value driven? Justify your selection.Discuss the financial results from your Pro Forma projections. Include the net income results, breakeven analysis, and required expenses to commercialize your product or service.Review your decision for a revenue model. Based on the financial statements, will this model generate a profit? Provide evidence to prove it. Consider the assumptions made when completing Part 3. What assumptions are made? List the assumptions that you used to formulate this plan. Where are you getting capital to meet your strategic initiative? What terms will be most likely deemed acceptable?What is the vital financial information needed to determine the viability of your plan ?What ratios will you use to determine if the proposed plan is a success?Questions Did you have to reevaluate (go back) why?What other, nonfinancial, information did you use to put your plan together?Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete?
Excel sheet help

Excel sheet help

Question # 00573694 Posted By: bsimental Updated on: 08/10/2017 07:14 PM Due on: 08/13/2017
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image
I need to have the excel sheet completed, and the question on it answered with regards to the company I have done.  I am attaching the excel sheet (all ready to go), and original company information.  It is all done, it just needs to be transferred and the questions answered.  If you need any more info. please let me know.  It is for Part 5 of my plan.
Dot Image
Attachments
Stategic_Plan_doc._.docx (328.81 KB)
ProjectedFinancialStatementAnalysis.xlsx (40.75 KB)
Tutorials for this Question
  1. neil2103
    Tutorial # 00571446 Posted By: neil2103 Posted on: 08/10/2017 09:11 PM
    Puchased By: 3
    Tutorial Preview
    The solution of Excel sheet help...
      Get the Solution
    Attachments
    Financials.xlsx (42.36 KB)
Whatsapp Lisa