[ad_1]
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 Excel’s 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 Percent 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.
[ad_2]
Testimonials
