George Wilkins checked the spreadsheet where he keeps track of his assets

and liabilities. He discovered that (i) he owes $80,000 on his house, which
he believes to be worth $150,000; (ii) his car is worth $20,000, against which
there is $2,000 on the remaining bank loan; (iii) his stock portfolio has risen to
$50,000; (iv) he has a $10,000 balance in his bank account, which is earning
a 1.2 percent annual interest rate; and (v) the value of his other belongings is
$45,000. He has just received his monthly paycheck for $6,000 and he is trying
to decide about taking a vacation and whether or not to pay off his car loan. His
monthly expenses are $3,000 which includes the interest expense on his auto
loan. He has two possible vacation choices: the Bahamas for $2,000 or a local
beach for $1,000. If he has any money left over at the end of the month, it will
go into his bank account. If he doesn’t have enough money to cover all of his
expenses for the month, he will sell enough of his stock to cover the excess
expenses.
Use a spreadsheet to input each of George’s assets, (i) to (v), in the first
column; the value of these assets in the second column; and the liabilities
(if any) against those assets in the third column. In the fourth column compute
the net asset value of each of the assets. Total the fourth column to determine
George’s net worth at the beginning of the month.
Compute the additional net income that George will have from his paycheck
plus the interest on his bank account minus the monthly expenses. Use this
information to answer parts (c) through (f) below.
Repeat part (a) for the end of the month assuming George does not take a
vacation and pays off his auto loan.
Repeat part (a) for the end of the month assuming George takes the Bahamas
vacation and only pays $1,000 on the principal of the auto loan.
Repeat part (a) for the end of the month assuming that George takes the local
beach vacation and pays off his auto loan.
Repeat part (a) for the end of the month assuming George takes the Bahamas
vacation and pays off the auto loan.

To solve this problem, we need to follow the steps outlined and input the given information into a spreadsheet. Let's break down the steps and calculations involved in each part.

Part (a):
1. Set up a spreadsheet with five columns: Asset, Value, Liability, Net Asset Value, and Net Worth.
2. Input the given values for assets and liabilities:
a. House: Value $150,000, Liability $80,000.
b. Car: Value $20,000, Liability $2,000.
c. Stock portfolio: Value $50,000, No Liability.
d. Bank account: Value $10,000, No Liability.
e. Other belongings: Value $45,000, No Liability.
3. Calculate the Net Asset Value for each asset by subtracting the liability from the value.
a. House: Net Asset Value = Value - Liability = $150,000 - $80,000 = $70,000.
b. Car: Net Asset Value = Value - Liability = $20,000 - $2,000 = $18,000.
c. Stock portfolio: Net Asset Value = Value = $50,000 (no liability).
d. Bank account: Net Asset Value = Value = $10,000 (no liability).
e. Other belongings: Net Asset Value = Value = $45,000 (no liability).
4. Total the Net Asset Value column to determine George's Net Worth at the beginning of the month.

Part (b):
1. Calculate George's additional net income for the month:
a. Paycheck: $6,000.
b. Bank account interest: $10,000 * 1.2% / 12 months = $10.
c. Monthly expenses: $3,000 (including $2,000 interest expense on the auto loan).
d. Additional net income = Paycheck + Bank account interest - Monthly expenses.
2. Update the spreadsheet by adding the additional net income to the Bank account's Net Asset Value column.
3. Total the Net Asset Value column to determine George's Net Worth at the end of the month.

Part (c), (d), and (e):
1. Follow the steps in Part (a) and (b) for the end of the month, assuming different scenarios (vacations and auto loan payments).
2. Update the spreadsheet accordingly by adjusting the values for the vacation expenses and auto loan payment.
3. Calculate the additional net income based on the given values in each scenario.
4. Update the Bank account's Net Asset Value column with the additional net income.
5. Total the Net Asset Value column to determine George's Net Worth at the end of the month for each scenario.

Part (f):
1. Follow the steps in Part (a) and (b) for the end of the month, assuming George takes the Bahamas vacation and pays off the auto loan.
2. Adjust the values in the spreadsheet accordingly.
3. Calculate the additional net income based on the given values.
4. Subtract the remaining auto loan principal ($2,000) from the Bank account's Net Asset Value column.
5. Total the Net Asset Value column to determine George's Net Worth at the end of the month in this scenario.