Question: There are 4 bold questions based on this reading can someone please help me figure these out!!! Jonny and Johanna are newlyweds, and have started

There are 4 bold questions based on this reading can someone please help me figure these out!!!

Jonny and Johanna are newlyweds, and have started to make their first budget, using the Excel Budget Tool introduced in FINL 100. Open/save this workbook, and enable the content. In the version downloaded with this link, they have already gone to the Customization sheet to exclude categories of income and expenses that dont apply to them (e.g. they rent, so they do not have property taxes, and they do not have children yet), and have edited other labels to fit their situation. Once the first month was set, they replicated the amounts for the next 11 months. The amounts are all cash, so the income is the take-home pay, after taxes and deductions for health and dental insurance, and retirement savings.

The focus of this analysis is not on tracking actual vs budget, as it was in FINL 100. Rather, it is on multi-period planning and lumpy expenses. The specific monthly amounts and the inclusion/exclusion of particular categories of expenses are made up, so would not likely match your experience. The couple owns their 2 cars with no debt. Their combined student loan payments are relatively small compared to some of their classmates, at $400 per month. All these figures have already been entered for you.

They have a total of $600 in their wallets and checking account at the beginning of the budget. Enter this amount in cell B150.

Jonny and Johanna see that their budget appears to be balanced. What is the estimated balance in December 2018?

Then in late January they see an adorable puppyfree. They research some online, and find the site https://www.moneyunder30.com/the-true-cost-of-pet-ownership. To incorporate this analysis into the budget, go to the Customization sheet and check all the boxes in the Pets section. Then select the Budget sheet again to see the new section.

In January, put the total one-time costs for dogs from the website into the Other row for Pets (the labeling of rows is not the point of this exercise). You want to remember how you came up with this estimate, so navigate to the website, drag over the 'One-time pet expenses' section, copy, then select the Excel sheet cell B88. Right-click, Comment, Paste. Expand the comment box so you can see all the text.

Then consider the total annual costs from the website, divide by 12, round to the closest integer, and enter this value in the Other row for February, figuring they can always break this value down into line items like Dog Food, Licensing, etc. later. Copy and paste the 'Annual pet expenses' section of the web page into the comment for February. Then copy/paste the February value into March through December. What is the ending balance in December 2018?

Then they realize they have not budgeted for summer travel or Christmas gifts. Put $1000 in July into one of the rows for vacations (again, you don't need to break it down) and $1000 in for gifts in December (overwriting the $50 that was in that cell). What is the ending balance forecast for December 2018?

Clearly that wont work. They decide to skip the $225 pet health insurance, so recalculate that amount and round to the nearest dollar. They also decide to tag along with their parents and in-laws for vacations, dropping the July figure to $300, and spend far less on Christmas presents, holding it to $200. They know these seems like small amounts. They hope that the unpredictable car repair and health/dental expenses will be lower than they budget for over the course of the year, so that they can do more. What is the estimated balance in December 2018?

They then observe that they end each month with a non-negative balance. They now can make a more informed decision about getting that puppy.

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