Question: Long shot because this will take a while but i have a project in accounting and these are the directions. Have no clue how to

Long shot because this will take a while but i have a project in accounting and these are the directions. Have no clue how to do the formulas.
 Long shot because this will take a while but i have
a project in accounting and these are the directions. Have no clue
how to do the formulas. Please read the instructions carefully and provide
what is being requested. A new client of yours, Sarah Rhinhart, 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 diner on the October 1, 2018. You, as an independent
consultant, have been hired to develop a cash pro forma budget for

Please read the instructions carefully and provide what is being requested. A new client of yours, Sarah Rhinhart, 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 diner on the October 1, 2018. 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). It can be used to plan for and manage the business if done correctly. Assignment: Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the file attached Excel Template "SugarFine Dessert Cafe Template" as your starting point. This is the file that must be downloaded and used as the basis for your assignment. Do not make any changes to this pre-defined template items. You may add extra worksheets as needed as well update the template. Do not use a template from a previous semester-this is considered academic dishonesty and will be subject to disciplinary action. Place the finished cash pro forma on a worksheet labeled "Cash ProForma. 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). Place your start-up costs on a third worksheet labeled "Startup Costs" Create two additional worksheets for your recommendations. Label one worksheet Flavored Coffee Recommendation", label the other Entertainment Recommendation". Appropriate Charts (graphs): You will be creating two separate charts so create and label two additional worksheets for the charts (each chart will be in its own worksheet) Chart One Monthly Product Revenue" -this will show the monthly revenue Please read the instructions carefully and provide what is being requested. A new client of yours, Sarah Rhinhart, 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 diner on the October 1, 2018. 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). It can be used to plan for and manage the business if done correctly. Assignment: Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the file attached Excel Template "SugarFine Dessert Cafe Template" as your starting point. This is the file that must be downloaded and used as the basis for your assignment. Do not make any changes to this pre-defined template items. You may add extra worksheets as needed as well update the template. Do not use a template from a previous semester-this is considered academic dishonesty and will be subject to disciplinary action. Place the finished cash pro forma on a worksheet labeled "Cash ProForma. 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). Place your start-up costs on a third worksheet labeled "Startup Costs" Create two additional worksheets for your recommendations. Label one worksheet Flavored Coffee Recommendation", label the other Entertainment Recommendation". Appropriate Charts (graphs): You will be creating two separate charts so create and label two additional worksheets for the charts (each chart will be in its own worksheet) Chart One Monthly Product Revenue" -this will show the monthly revenue

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!