Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART B Excel Refresher template provided 1. Create a 12-month family projected budget that reflex income and expenses. 2. Add totals, For the first

image text in transcribed

PART B Excel Refresher template provided 1. Create a 12-month family projected budget that reflex income and expenses. 2. Add totals, For the first total it should include B2-B5 total should be placed to B6. Do the same for C with totals C6 up to M6 3. Income 1-3 should be 2,000 each for all months 4. Expenses should be the same for all months 5. Calculate totals for B8-B12 total should be placed in B13 do the same for February expenses up to December. 6. Calculate subtotal variable mandatory cost B19-M19 using cost of B15 through B18. All cost should be the same for now. 7. Calculate subtotal variable msic cost for January expenses B27 use B22-B26 to calculate total for B27 do the same for February - December 8. Calculate ending balance by adding total expenses and total income. 9. Beginning balance starting February each month beginning balance should be the previous month ending balance. 10. Prepare a 12-month cash flow spreadsheet to record actual income and expense budget. Part C 1. Assume gas cost is going up 1% every month starting February 2. Assume electrical cost is going up 2% every month starting March 3. Assume income goes up in July by 25% 4. Assume other travel supplies etc goes down 3% starting July Answer the below questions after making the changes above by highlighting in yellow on the spreadsheet and answering it below. 5. What is the ending balance at the end of December? 6. In what month does ending balance become positive 7. What month is the lowest ending balance? 8. Which month shows the highest positive begging balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Managerial Accounting

Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

6th edition

1305103963, 978-1305548909, 1305548906, 978-1305103962

More Books

Students also viewed these Accounting questions

Question

Who are most likely to be victimized by a phishing expedition?

Answered: 1 week ago

Question

What is the E&M code for this case

Answered: 1 week ago

Question

What did you feel?

Answered: 1 week ago

Question

How did you feel at home?

Answered: 1 week ago

Question

Who did you talk to about the new situation?

Answered: 1 week ago