Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ACCT - 3 2 2 Budgeting - Financial Modeling Assignment For this assignment, groups can be formed of up to 3 people. You also have
ACCT Budgeting Financial Modeling Assignment
For this assignment, groups can be formed of up to people. You also have the option of doing the
assignment in pairs. Only one person in your group will submit a finalized master budget, so decide
who that will be
The project will require you to use Microsoft Excel to complete and automate a budget. I am looking
for your budgeting skills as well as your excel skills in this assignment. I want a professionally
presented document.
In a properly built spreadsheet, if the input numbers are changed, then all the
supporting schedules should automatically update.
Required:
Read the case "Cravat Sales Company".
Prepare the following budgets and schedules for the second quarter April June using MS
Excel.
A Sales budget for April, May, and June.
A cash collections budget from sales for April, May, and June.
A purchase budget inventory in units and in dollars for April, May, and June.
A cash payment budget for inventory for April, May, and June.
A selling and admin. operating expenses budget for April, May, and June.
A cash payment budget for selling and admin. operating expenses for April, May, and June.
A Cash budget for April, May, and June.
There should be no manual input into the Output Section. All cells are to contain formula.
Read the helpful hints given below
Hand in:
Your excel file and be sure to keep a backup copy of your file. Please use the following naming
convention: First nameLast nameBudgeting assignment eg HumayunQadri Budgeting
assignment
Note:
Please remember that each group is to work independently. You are not allowed to share files
between groups. If you share your excel file, I will give the group who gave the file and also the
receiving group a grade of zero and report you to the MacEwan Academic Integrity Officer. It is
important for each group to earn the grade that they receive. If you have any questions, please
discuss with me I don't want you to put yourself in a difficult situation.
Helpful Hints
Remember to save frequently. Also, check for viruses.
Don't forget the following characteristics of a good spreadsheet:
it works
it looks neat and is well organized
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