Question

In: Accounting

What is the total current assets at the beginning of Q2 FY2016?

Cash = $1,505,000; Rent Receivable = $250,000; Prepaid Expenses = $100,000; Building = $10,500,000; Prepaid Insurance = $150,000; Insurance Expense = $350,000; Unearned Revenue = $50,000; Accounts Payable = $100,000; Accrued Liabilities = $45,000; Salaries Expense = $550,000; Shareholders’ Capital = $12,310,000. In addition, the company had the following transactions during Q2 that ended on June 30, 2016: The company’s total rental revenue for Q2 FY2016 was $2,500,000. Of this amount $2,000,000 was collected during Q2 FY2016. $230,000 of the Rent Receivable outstanding at the beginning of the quarter was collected during Q2 FY2016. The company incurred total operating expenses of $850,000 for Q2 FY2016. All these expenses were paid except $50,000. 

What is the total current assets at the beginning of Q2 FY2016? 

What is the total current liabilities at the beginning of Q2 FY2016? 

Present the balance sheet at the end of Q2 2016.


Solutions

Expert Solution

As per the information given, balance sheet as at the beginning of Q2 2016 will be as follows:

Balance Sheet as at the Beginning of Q2 2016

Liabilities Amount Assets Amount
Shareholders’ Capital 12,310,000 Cash 1,505,000
Unearned Revenue 50,000 Rent Receivable 250,000
Accounts Payable 100,000 Prepaid Expenses 100,000
Accrued Liabilities 45,000 Prepaid Insurance 150,000
Building 10,500,000
12,505,000 12,505,000

From the above balance sheet total assets as at the beginning of Q2 FY 2016 is calculated as follows:

Particulars Amount
Cash 1,505,000
Rent Receivable 250,000
Prepaid Expenses 100,000
Prepaid Insurance 150,000
Total 2,005,000

Similarly, total current liabilities as at the beginning of Q2 FY 2016 is calculated as follows:

Particulars Amount
Unearned Revenue 50,000
Accounts Payable 100,000
Accrued Liabilities 45,000
Total 195,000

Now let us prepare important ledger accounts based on the transactions during the quarter to arrive at the closing balances for preparing balance sheet as at the end of the quarter:

Rent Receivable A/c
Particulars Debit Particulars Credit
To Balance b/f             250,000 By Cash        2,000,000
To Rent         2,500,000 By Cash            230,000
By Balance c/f            520,000
       2,750,000        2,750,000
Cash A/c
Particulars Debit Particulars Credit
To balance b/f         1,505,000 By operating expenses            800,000
To rent receivable         2,000,000 By Balance b/f        2,935,000
To rent receivable             230,000
        3,735,000 3,735,000
Accounts Payable A/c
Particulars Debit Particulars Credit
To Cash 800,000 By Balance b/f 100,000
To balance b/f 150000 By Operating Expenses 850,000
950,000 950,000
P&L A/c
Particulars Debit Particulars Credit
To Operating Expenses 850,000 By Rent        2,500,000
To net profit (transferred to shareholder's equity)        1,650,000
       2,500,000        2,500,000

Based on above balances, Balance Sheet at the end of Q2 2016 will be as follows:

Balance Sheet as at the end of Q2 2016

Liabilities Amount Assets Amount
Shareholders’ Capital (12,310,000+1,650,000) 13,960,000 Cash 2,935,000
Unearned Revenue 50,000 Rent Receivable 520,000
Accounts Payable 150,000 Prepaid Expenses 100,000
Accrued Liabilities 45,000 Prepaid Insurance 150,000
Building 10,500,000
14,205,000 14,205,000

Related Solutions

At the beginning of the current year, Trenton Company's total assets were 258,000 and its total...
At the beginning of the current year, Trenton Company's total assets were 258,000 and its total liabilities were 180,000 during the year the company reported total revenues of 103,000, total expenses of 81,000 and dividends of 10,000. There were no other changes in equity during the year and total assets at the end of the year were 270,000. Trenton Company's debt ratio at the end of the current year is. A 50.0%. B 1.50%. C 66.7% D 33.3% E 69.8%
At the beginning of the current year, Snell Co. total assets were $282,000 and its total...
At the beginning of the current year, Snell Co. total assets were $282,000 and its total liabilities were $191,200. During the year, the company reported total revenues of $127,000, total expenses of $93,000 and dividends of $22,000. There were no other changes in equity during the year and total assets at the end of the year were $294,000. The company's debt ratio at the end of the current year is: A: 35.0%. B: 65.0%. C: 67.8% D: 147.00% E: 53.8%
Balance the budget sheet: Current Assets: Total Current Assets: Property and equipment: Other assets: Total Assets:...
Balance the budget sheet: Current Assets: Total Current Assets: Property and equipment: Other assets: Total Assets: Current liabilities: Total Current Liabilities: Total Liabilities: Share holders equity Total Liabilities & Share holders Equity: Instructions: Please place the following items and amounts in their correct locations on the balance sheet Accounts payable $30,000 Accounts receivable $20,000 Investments $10,000 Common stock $10,000 Additional paid-in capital $20,000 Prepaid expense $4,000 Cash and cash equivalents $100,000 Deferred revenue $2,000 Notes payable $10,000 Inventory $15,000 Retained...
Q1: The total assets and the total liabilities of a business at the beginning and at...
Q1: The total assets and the total liabilities of a business at the beginning and at the end of the year appear below. During the year, the corporation paid cash dividends of $24,000 and the stockholders made an additional investment of $15,000. Assets   Liabilities Beginning of year $395,000 $190,000 End of year 555,000 320,000 The amount of net income or net loss for the year was Group of answer choices net income of $54,000. net income of $30,000. net loss...
What was Gannon’s total current assets at the end of 2017?
YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT.                                                                         2016                            2017 BALANCE SHEETS: Accounts Receivable520,000620,000                         Fixed Assets, net                     410,000                       510,000 Total Assets1,355,0001,580,000 Liabilities and Equity: Accounts Payable350,000$375,000 Long-term Debt500,000625,000 Common Stock50,00075,000                         Retained Earnings                   455,000                       505,000 Total Liabilities and Equity1,355,0001,580,000 INCOME STATEMENT:             Revenue                                                                                  3,500,000             Cost of Goods Sold                                                                2,275,000             General and Administrative                                                     515,000             Depreciation Expense                                                              120,000             Earnings Before Interest and Taxes                                         590,000             Interest Expense                                                                      40,000             Pretax Net Income                                                                   550,000             Income Taxes                                                                          167,000             Net Income                                                                              383,000             What was Gannon’s total current assets at...
A firm’s total current assets are 18.3% of total assets, thecurrent ratio is 1.98, and...
A firm’s total current assets are 18.3% of total assets, the current ratio is 1.98, and the quick ratio is 1.46. What is the firm’s inventory, in % of assets? Round to the nearest 0.1%, drop the % symbol. E.g., if your answer is 5.45%, record it as 5.5.  
1. Quick Ratio= current assets-inventories/ current liabilities 2. Debt to Assets ratio= total debt/total assets 3....
1. Quick Ratio= current assets-inventories/ current liabilities 2. Debt to Assets ratio= total debt/total assets 3. Earnings Per Share (EPS)=total earnings/outstanding shares (must first solve net income-preferred divideneds= total earnings) 4. Net Income (Net profit)=total revenues-total expenses I need help finding the answer to these equations for Target Corporation for 2015 and 2016. please refer to the links for the 10k reports for the company. 2015- https://corporate.target.com/_media/TargetCorp/annualreports/2015/pdfs/Target-2015-Annual-Report.pdf 2016- https://corporate.target.com/_media/TargetCorp/annualreports/2016/pdfs/Target-2016-Annual-Report.pdf?ext=.pdf
($ in millions) Current assets 115 Fixed and other assets 165 Total assets 280 Current liabilities...
($ in millions) Current assets 115 Fixed and other assets 165 Total assets 280 Current liabilities 81 Long-term debt 48 Stockholders' equity 151 Total liabilities and equity 280 Common shares outstanding (millions) 14 Total revenues 436 Total operating costs and expenses 350 Interest expense 15 Income taxes 23 Net profits 48 Dividends paid to common stockholders 13 On the basis of this​ information, calculate as many​ liquidity, activity,​ leverage, profitability, and common stock measures as you can. ​(​Note: Assume the...
At the beginning of the year, a firm has current assets of $332 and current liabilities...
At the beginning of the year, a firm has current assets of $332 and current liabilities of $236. At the end of the year, the current assets are $501 and the current liabilities are $276. What is the change in net working capital? Multiple Choice $129 $0 $169 –$129 $209
A firm has Current Assets of $500,000, Inventory of $200,000, Current Liabilities of $700,000, Total Assets...
A firm has Current Assets of $500,000, Inventory of $200,000, Current Liabilities of $700,000, Total Assets of $3,000,000 and Total Liabilities of $3,500,000. Which of the following statements is correct: a. this firm is bankrupt b. this firm has a Quick Ratio that is greater than one c. this firm has positive equity d. this firm is technically insolvent
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT