Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please read the instructions carefully and provide what is being requested. A new client of yours, Blanche Greene, wants to open a small diner selling
Please read the instructions carefully and provide what is being requested. A new client of yours, Blanche Greene, wants to open a small diner selling calamari, oysters, fried shrimp, catfish sandwiches, salads, French fries, and sodas. He is planning to open the diner on the July 1, 2017. 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). t can be used to plan for and manage the business if done correctly. Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the attached Excel Template- Excel Assignment Diner 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-designed template except to add your information for the diner. 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 "Beer Recommendation", label the other "Entertainment Recommendation" Please read the instructions carefully and provide what is being requested. A new client of yours, Blanche Greene, wants to open a small diner selling calamari, oysters, fried shrimp, catfish sandwiches, salads, French fries, and sodas. He is planning to open the diner on the July 1, 2017. 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). t can be used to plan for and manage the business if done correctly. Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the attached Excel Template- Excel Assignment Diner 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-designed template except to add your information for the diner. 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 "Beer Recommendation", label the other "Entertainment Recommendation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started