This is a marketing assignment, but has to come up with a Finance strategy for a new business venture.Need assistance in figuring out and creating an excel spreadsheet with the following items that's on the attachment. This is for a market live requirement. The attachment has two sheets with description. It's veryimportant to use all information from both sheets and put all of them together in one spreadsheet. There needs to be quarterly information. By looking at the data on attachment, the main requirement is to determinehow much budget (good starting point)to have for this new businessprior to spending for stuff.Please see attachment for more details.

Budget for New Sales Offices and R&D Unused finances from prior quarter carried forward + Operating profit (loss) from prior quarter 934,900 -770,000 Net investment in the Marketing Division 164,900 + New finances from Corporate Headquarters for new business investment 500,000 Total financing available for new investment 664,900 - Research and development cost for new brand features 0 - Sales office set up costs Unused finances (cash) available for new investment 0 664,900 Projected demand per quarter Previous Demand Brand Projected Demand Selling Price CC #1 Inno #1 Mer #1 WH #1L 0 0 0 0 0 0 0 0 0 0 0 0 Trav #1L 0 0 0 Pro Forma Profitability of Marketing Division Quarter 1 Quarter 2 Quarter 3 Revenues 0 0 0 - Rebates 0 0 0 - Cost of Goods Sold 0 0 0 Gross profit 0 0 0 Sales Office Leases 0 0 151,000 + Sales Force Expense 0 0 0 + Brand Promotions 0 0 0 + Special Programs 0 0 0 + Ad Creation/Revision 0 0 0 + Point of Purchase Display Expenses 0 0 0 Gross Profit Expenses + Advertising Expenses 0 0 0 + Engineering Cost for New Brands 0 420,000 0 + Market Research 65,100 0 0 Err:509 65,100 420,000 151,000 -65,100 -420,000 -151,000 + Other Income 0 0 0 - Other Expenses 0 0 0 - Research and Development Costs 0 0 0 - Set Up Costs for New Sales Offices 0 350,000 0 Net Profit for Division -65,100 -770,000 -151,000 Cumulative Net Profit for Division -65,100 -835,100 -986,100 Operating profit Miscellaneous Income and Expenses