Question: LAB: EXCEL BUDGET AND WHAT-IF ANALYSIS ASSIGNMENT INSTRUCTIONS OVERVIEW Believer or non-believer personal financial management is just the smart thing to do. As servants of

LAB: EXCEL BUDGET AND WHAT-IF ANALYSIS ASSIGNMENT INSTRUCTIONS OVERVIEW Believer or non-believer personal financial management is just the smart thing to do. As servants of Christ, it is critical for us to understand that God truly owns it all as seen in (Psalm 24:1 NIV) which says, "God owns it all and I am a manager of His resources." As stewards, we open our hands to God and recognize that all money is God's to give or take away. Rooted in that central understanding, personal finances should be broken into the five categories of Live, Give, Grow, Owe Taxes, and Owe Debt without any leftover funds. Throughout life, the percentages you contribute to each category may change but they all stay present except for the category of Owe Debt which the financial manager in each of us would hope to eliminate. This all starts with a personal budget. INSTRUCTIONS In this lab, we will use Excel to develop and budget and analyze it with Excels powerful What-if analysis. In the end of this assignment, you will need to submit a single Excel Workbook with four (4) worksheets. Master Budget Simple Precent Increase What-if Goal Seek Scenario Summary (you create the Scenario and Excel generated this worksheet) Please see the Lab: Excel Budgeting and What-if Assignment Tutorial for step-by-step instructions and use the Lab: Excel Budget and What-if Starter Template to get started.

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 Databases Questions!