Question

In: Accounting

Creating a Balance Sheet based on the information below: A couple, Timmy and Jenny have come...

Creating a Balance Sheet based on the information below:

A couple, Timmy and Jenny have come to see you regarding their financial situation. Timmy works for a consulting firm earning $80,000 per annum (take home pay of $2286.47 per fortnight after tax and other deductions). Jenny is currently a stay home mother taking care of their one-year-old child, which saves them in child care expenses of $450 per week. Before having the baby, Jenny worked as an early childhood teacher earning $45,000 per year ($1401.00 after tax and other deductions). They know that money has been tight and they have only saved $3,000 in a current account.

---------------------------------------------

Timmy and Jenny have provided the following information to you:  

- The couple are currently renting a house which is costing them $450 per week.

-They have two cell phones each on $40 per month plans

- Power bills estimated to be $150 per month

- Internet and phone plan cost them $70 per month

- They spend about $150 per week on incidental expenses like clothing and entertainment

- Food costs them about $150 per week

- Timmy buses to work with his monthly bus pass costing $120 per month

- The couple also have a car that they have just bought for $15,000 with a 5-year loan at 14.75%. The car comes with costs of $287.75 per year for registration and needs two warrants of fitness per year costing $60 each

- They spend $25 per week on petrol

- The car is now worth $12,000

- In terms of debt, they have $7,000 of personal loan which they pay 151.67 per month.

- They also recently replaced some household appliances and so have hire purchase debt of $4,600 which is costing them $150 per fortnight in repayments for the next 3 years

- Both the personal and hire purchase have interest rates of 22.5%

- The value of their household items, including their hire purchase items is $15,000

- Timmy has accumulated $1750 in his Rabosaver (a type of saving account) fund account.

-------------------------

Based on the above information, calculate:

1) Timmy and Jenny's Asset, Liability, and Net Worth (Balance Sheet)

Solutions

Expert Solution

            Liabilities                             assets

Loss is     11294.97

66170.25-54875.28    -                  current account -3000

2286.47*24= 54875.28                       car                   12000

less rent =     23400                        hire pur items        15000

phone               960                           saving                  1750

power 1800                        Total                     31750

internet              840

exp                   31200

bus                    1440

loan int -             2212.50

petrol                  1300

regn                    287.75

maint                 120

int p loan             1575

hp int                    1035

loan                                             15000

personal loan                                   7000

hire purchases                                 4600

His assets is 31750 and liabilities are 26600 ( 15000+7000+4600)

hence net worth is 5150 (31750-26600)

It is presumed that personal loan , hire purchases and car instalment not yet started .


Related Solutions

Creating a Balance Sheet based on the information below: A couple, Timmy and Jenny have come...
Creating a Balance Sheet based on the information below: A couple, Timmy and Jenny have come to see you regarding their financial situation. Timmy works for a consulting firm earning $80,000 per annum (take home pay of $2286.47 per fortnight after tax and other deductions). Jenny is currently a stay home mother taking care of their one-year-old child, which saves them in child care expenses of $450 per week. Before having the baby, Jenny worked as an early childhood teacher...
Based on the balance sheet below: Use your trial balance and the additional information below to...
Based on the balance sheet below: Use your trial balance and the additional information below to prepare: a. the statement of profit or loss for the two months ended on 31 December 2018 (in a vertical format). b. the statement of financial position as at 31 December 2018 (classify assets and liabilities into non-current and current). Additional information at the year-end requiring adjustments in the financial statements: a)Depreciation on office equipment is recorded on the straight-line basis and calculated per...
Based on the following financial information, construct the balance sheet and income statement below for Tonka...
Based on the following financial information, construct the balance sheet and income statement below for Tonka Trucking LLC for the year ending December 31, 2019. Be sure to format them as accurately as possible. Accounts Receivable $40,000 Depreciation Expense $50,000 Accumulated Depreciation $200,000 Cost of Goods Sold $50,000 Income Tax Expense $50,000 Cash $50,000 Sales Revenue $400,000 Equipment (Net of Accumulation) $200,000 Selling, General, and Administrative Expenses $100,000 Common Stock (1,000 shares) $100,000 Accounts Payable $50,000 Retained Earnings $200,000 Interest...
Based on the information below create an income statement, balance sheet, and cash flow statement. On...
Based on the information below create an income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in legal fees,...
A delivery company is creating a balance sheet.
A delivery company is creating a balance sheet. Which of the following would most likely be considered a short-term liability on this balance sheet? the depreciation over the last year in the value of the vehicles owned by the company revenue received for the delivery of items that have not yet been delivered prepaid rent on the offices occupied by the company a loan which must paid back in two years
Based on the information below create the year end income statement, balance sheet, and cash flow...
Based on the information below create the year end income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the year 2012. Please show your workings for the related questions below (yes, all together!). If your final answers (below) are incorrect, I'll review your workings to grant partial credit. Trial Balance as at 31st December 2012 Trial Balance Dr Cr Sales 240,000 Purchases 150,000 Returns inwards 5,000 Returns outwards 6,000 Carriage Inwards 3,000 Inventory 1.1.2012 80,000 Salaries 25,000 Electricity and telephone 4,000 Rent 5,000...
A bank’s balance sheet information is shown below (in$000).On Balance Sheet ItemsFace Value...
A bank’s balance sheet information is shown below (in $000).On Balance Sheet ItemsFace ValueCash$141,600Short-term government securities (<92 days)7,400Long-term government securities (>92 days)434,400Federal Reserve stock11,800Repos secured by federal agencies179,000Claims on U.S. depository institutions957,900Loans to foreign banks, OECD CRC rated 21,840,000General obligation municipals190,000Claims on or guaranteed by federal agencies28,500Municipal revenue bonds132,900Residential mortgages, category 1, loan-to-value ratio 75%7,000,000Commercial loans6,667,669Loans to sovereigns, OECD CRC rated 313,600Premises and equipment475,000Off Balance Sheet Items:Conversion Factor (%)Face ValueU.S. Government CounterpartyLoan commitments:<1 year20$3001–5 year501,140Standby letters of credit:Performance-related50200Direct-credit substitute100100U.S. Depository...
Ive been tasked with creating a cash flow statement for the below balance sheet item and...
Ive been tasked with creating a cash flow statement for the below balance sheet item and profit and loss items, I've finished it on my own but the operating activities im not too sure on; Balance sheet; ASSETS 2018 2019 cash 33400 25000 A/C Rec 37000 61060 Consultation service Receivable 1000 2000 Inventory 102650 121900 Prepaid Insurance 9500 6500 Land 107000 84500 Property, plant & equipment 205000 310000 Accum Dep'n - PP&E (40000) (46500) LIABILITIES & EQUITY A/c paybale 48280...
For the information provided below, prepare a balance sheet statement.
For the information provided below, prepare a balance sheet statement.The value of the land is $100,000 and the value of the building is $1,010,000.The current portion of the bonds payable is $80,000.The current portion of the notes payable is $50,000.The current portion of mortgage payable is $35,000.The marketable securities are being held to be sold if and when cash might be needed.The name of the company is UAN.The amounts shown are the ending amounts from the period from January 1,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT