Sparkles Dessert Cafe Please read the instructions carefully and provide what is being requested. A new client of yours, Bailey Waters wants to open a small dessert cafe selling cupcakes, pie slices, custard, ice cream cones, yogurt parfaits, cake slices, and sodas. She is planning to open the cafe on the August 1, 2020. You, as an independent consultant, have been hired to develop a cash pro forma budget for his business venture (note: this is a spreadsheet that helps forecast income and expenses over a period of time). The plan will be used to manage the business and apply for a loan. Assignment: Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. 1. Use the Excel Template file attached "Sparkles Dessert Cafe Template" as your starting point. Download and use as the basis for your assignment 2. Do not make any changes to this pre-defined template items. 3. You may add your information to the existing sheets. 4. You may add extra worksheets as needed to the template file. 5. Do not use a template from a previous semester - this is considered academic dishonesty and will be subject to disciplinary action. 6. Place the finished cash pro forma on a worksheet labeled "Cash ProForma" 7. Place all your case assumptions data on a separate worksheet Label the worksheet "Assumptions" (note: each piece of data must appear in its own cell on the Assumption sheet) 8. Place your start-up costs on a third worksheet labeled "Startup Costs". Sparkles Dessert Cafe Please read the instructions carefully and provide what is being requested. A new client of yours, Bailey Waters wants to open a small dessert cafe selling cupcakes, pie slices, custard, ice cream cones, yogurt parfaits, cake slices, and sodas. She is planning to open the cafe on the August 1, 2020. You, as an independent consultant, have been hired to develop a cash pro forma budget for his business venture (note: this is a spreadsheet that helps forecast income and expenses over a period of time). The plan will be used to manage the business and apply for a loan. Assignment: Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. 1. Use the Excel Template file attached "Sparkles Dessert Cafe Template" as your starting point. Download and use as the basis for your assignment 2. Do not make any changes to this pre-defined template items. 3. You may add your information to the existing sheets. 4. You may add extra worksheets as needed to the template file. 5. Do not use a template from a previous semester - this is considered academic dishonesty and will be subject to disciplinary action. 6. Place the finished cash pro forma on a worksheet labeled "Cash ProForma" 7. Place all your case assumptions data on a separate worksheet Label the worksheet "Assumptions" (note: each piece of data must appear in its own cell on the Assumption sheet) 8. Place your start-up costs on a third worksheet labeled "Startup Costs
