Question

Liam and Marta live in London. Both are teachers, with Liam in full time and Martart-time...

Liam and Marta live in London. Both are teachers, with Liam in full time and Martart-time paid employment. When they bought a flat together in June 2018 the mortgage broker talked them through repayment and interest-only mortgages. They decided to use their savings as a deposit and chose a repayment mortgage, which by June 2020 was standing at £100,000. The market value of their flat had increased by 10% over this time period on the original purchasing price of £110,000.

Together, in June 2020 the couple earn a net monthly income of £4000 and their expenditure has averaged £4200 a month over the last two years. In June 2020 their car loan is down from £4,000 to £2,500, their current account balance has dropped to zero and they have an overdraft on their current account of £1500. Meanwhile their savings account holds just £300. They also owe £3000 on a credit card. The rest of their balance sheet has not changed since June 2018.  

They are reviewing their finances as they are considering improving their home by installing a new kitchen.

Table 1 shows their balance sheet and financial ratios in June 2018.

Table 1 Liam and Marta’s household balance sheet – June 2018

June 2018

Assets

113,120

Liquid assets

3,120

Cash

120

Current account

2,000

Instant access savings account(s)

1,000

Other liquid assets

0

Other assets

110,000

Home

110,000

Liabilities

110,000

Short-term liabilities

1,000

Overdraft

0

Credit card

1,000

Other short-term liabilities

0

Other liabilities

109,000

Personal loans

4,000

Mortgage

105,000

Ratios

Net worth / wealth

3,120

Current asset ratio

3.12

Leverage ratio

97.24

 Using the information provided in Table 1, complete the couple’s balance sheet for June 2020.

Homework Answers

Answer #1
Jun-18 Jun-20 Remarks
Assets 113,120 121,420
Liquid assets 3,120 420
Cash 120 120 Same
Current account 2,000 0 Zero
Instant access savings account(s) 1,000 300 Decreased
Other liquid assets 0 0
Other assets 110,000 121,000
Home 110,000 121,000 10% increase in Market Value
Liabilities 110,000 107,000
Short-term liabilities 1,000 4,500
Overdraft 0 1,500 Overdrawn 1500
Credit card 1,000 3,000 Owe 3000
Other short-term liabilities 0 0
Other liabilities 109,000 102,500
Personal loans 4,000 2,500 Reduced to 2500
Mortgage 105,000 100,000 Reduced to 10000
Net worth
Net worth / wealth 3,120 14,420

Note:- All the information as per the question has been updated while preparing the balance sheet of June - 2020.No information is given about cash,hence the same has been kept at the same level.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using the following balance sheet items and amounts, calculate the total liquid assets and total current...
Using the following balance sheet items and amounts, calculate the total liquid assets and total current liabilities: Money market account $ 3,450 Medical bills $ 398 Mortgage $ 154,000 Checking account $ 950 Retirement account $ 94,200 Credit card balance $ 659 a.Total liquid assetsb.= b.Total current liabilities=
2018 2017 Balance Sheet: Current Assets Current Liabilities Net Fixed Assets Long-Term Debt Common Stock Income...
2018 2017 Balance Sheet: Current Assets Current Liabilities Net Fixed Assets Long-Term Debt Common Stock Income Statement/Other: Depreciation Expense EBIT Interest Expense Taxes Net Income Dividends $ 5,000     2,000   10,000   11,000     7,500 $ 1,000     4,000     2,000        500      1,500        600 $ 7,000     4,500     8,000     9,500     7,400 Calculate the following Cash Flow from Assets Questions: 1. Operating Cash Flow 2. Net Capital Spending 3. Changes in Net Working Capital 4. Cash...
You have been provided with the Balance Sheet and Income Statement for OSR Pty Ltd as...
You have been provided with the Balance Sheet and Income Statement for OSR Pty Ltd as at 30 June 2020 with 2019 comparatives to prepare an analysis for the performance of OSR Pty Ltd: OSR Pty Ltd    Account Balance   As at 30 June 2020 2019 Assets $ $ Cash $30,000 $19,200 Accounts receivable $49,200 $44,100 Inventory $84,000 $82,800 Property, plant and equipment $312,000 $312,000 Total Assets $475,200 $458,100 Liabilities Accounts Payable $57,000 $67,200 Mortgage payable $120,000 $120,000 Total Liabilites $177,000...
Select the 10 ratios you deem most important financial ratios.  (Show these in Excel together with illustrative...
Select the 10 ratios you deem most important financial ratios.  (Show these in Excel together with illustrative graphs you deem appropriate). Based on your analysis of your ratio answer 2) What 3 items of important information does the balance sheet ratios reveal about the financial position of the company? Current Assets Cash 49.88 Receivables 139.53 Prepaid Expenses 11.09 Inventories 501.71 Investments 0.62 NCA Held Sale 52.28 Other 0.00 Total Current Assets 755.12 Non-Current Assets Receivables 0.00 Inventories 0.00 Investments 0.74 PP&E...
Liquidation At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel...
Liquidation At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining Company had the following balance sheet shown below (in thousands of dollars). The court, after trying unsuccessfully to reorganize the firm, decided that the only recourse was liquidation under Chapter 7. Sale of the fixed assets, which were pledged as collateral to the mortgage bondholders, brought in $430,000, while the current assets were sold for another $240,000. Thus, the total proceeds from the...
Your friend has asked you to produce financial statements for his business, Mates Incorporated, for the...
Your friend has asked you to produce financial statements for his business, Mates Incorporated, for the year 1 July 2015 to 30 June 2016. To make your job a little more difficult he has produced his adjusted trial balance in alphabetical order as he was unaware of the proper order. Produce an Income Statement and Balance Sheet (either select from the Drop Down menu or enter an account or number in blank boxes). Do not use any form of punctuation...
How would you write these journal entries? DFC acquired $400,000 of SeBASS, INC 3% Bonds at...
How would you write these journal entries? DFC acquired $400,000 of SeBASS, INC 3% Bonds at face (par) value during fiscal 2018. The bonds pay interest semi-annually on February 1st and August 1st. DFC correctly classified the bonds as Available-for-Sale Securities (AFS). On June 1, 2019, DFC put a new roof on the administrative building. The cash cost of the new roof was $48,000 and is expected to add 13 years to the life of the building from the date...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is trend in Liquidity ratios of CVS over the last three years - Explain using ratios and three sentences? b. What is trend in Liquidity ratios of Walgreens over the last three years - Explain using rations and three sentences? c. Which company has had better Liquidity ratios over the last 3 years? Explain with ratios and three sentences CVS Balance Sheet All numbers in...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is trend in profitability ratios of CVS over the last three years - Explain using ratios and three sentences? b. What is trend in profitability ratios of Walgreens over the last three years - Explain using rations and three sentences? c. Which company has had better profitability ratios over the last 3 years? Explain with ratios and three sentences CVS Balance Sheet All numbers in...
Liquidation At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel...
Liquidation At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining Company had the following balance sheet shown below (in thousands of dollars). The court, after trying unsuccessfully to reorganize the firm, decided that the only recourse was liquidation under Chapter 7. Sale of the fixed assets, which were pledged as collateral to the mortgage bondholders, brought in $320,000, while the current assets were sold for another $230,000. Thus, the total proceeds from the...