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.
a. 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.
b. 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.
c. Repeat part (a) for the end of the month assuming George does not take a vacation and pays off his auto loan.
d. 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.
e. Repeat part (a) for the end of the month assuming that George takes the local beach vacation and pays off his auto loan.
f. Repeat part (a) for the end of the month assuming George takes the Bahamas vacation and pays off the auto loan.

1. 👍
2. 👎
3. 👁

## Similar Questions

1. ### ELA

If the author wanted to rewrite this story as a play with dramatic irony, what change would be MOST effective? A) Coach Wilkins would prepare a speech and share his feelings about retirement. B) The chorus would sing the school's

2. ### Personal Finance

Janice Jacobs is planning for her retirement. She knows what assets and liabilities she has now and expects to have in the future. She knows what her spending patterns are likely to be and adjusted them for inflation. She also has

3. ### finance

A firm's long term assets = \$75,000, total assets = \$200,000, inventory = \$25,000 and current liabilities = \$50,000.

4. ### Finance

Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts: ASSETS Cash \$25,000 3.4% Accounts receivable \$125,000 _____ Inventory _______ 27.1% Total current assets \$350,000 ______ Gross

1. ### Accounting

A credit to a liability account was posted to an owner's equity account. This would cause __________. A. assets to be overstated B. liabilities to be understated C. owner's equity to be understated D. net income to be overstated i

2. ### office finances

what can a computerized spreadsheet do that a paper spreadsheet cant b.keep track of financial data c.recalculate itself after changes my answer is c

. 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

4. ### Accounting Math

Can anyone please show me the calculation for these problems: Burlin Company starts the year with \$100,000 in assets and \$80,000 in liabilities. Net Income for the year is \$25,000, and no dividends are paid. How much is owner’s

1. ### Accounting

Dividing Partnership Income Desmond Drury and Ty Wilkins have decided to form a partnership. They have agreed that Drury is to invest \$44,700 and that Wilkins is to invest \$104,300. Drury is to devote full time to the business,

2. ### accounting

A company borrows money on a line of credit. Possible answers: increase assets increase equity increase liability decrease assets decrease liabilities decreases equity

3. ### Accounting

At the beginning of the year, Keller Company's liabilities equal \$60,000. During the year, assets increased by \$80,000, and at year-end assets equal \$180,000. Liabilities decrease \$10,000 during the year. What are the beginning

4. ### Math

On March 31, 2009, Wolfson Corporation acquired all of the outstanding common stock of barney Corporation for \$17,000,000 in cash. The book values and fair values of barney's assets and liabilities were as follows: Book value Fair