Michael J owns renovation business under the name New Home

Michael J owns renovation business under the name New Home. Financial data for New Home as of 30 June 2019 are shown as below:

	$		$
Accounts receivable	109,500	Wages expense	117,000
Renovation revenue	300,000	Advertising expense	48,000
Interest Income	13,500	Prepaid insurance	13,500
Accounts payable	132,000	Insurance expense	10,500
Cash at bank	72,000	Equipment	285,000
Michael J, capital	?

 

Required:

a) Prepare an income statement for the business for the year ending 30 June 2019.
b) Prepare a balance sheet in narrative format for New Home as at 30 June 2019.

Melissa Ltd purchased all the issued shares of Soren Ltd

Melissa Ltd purchased all the issued shares of Soren Ltd for $1115000 on 1 July 2020 when the equity of Soren Ltd was as follows; Share capital 446000 General reserve 334500 Asset revaluation surplus 167250   At this date, Soren Ltd had not recorded any goodwill, and all identifiable assets and liabilities were recorded at fair value except for the followings;   Account Cost Carrying Amount Fair value Further life(Years) Inventories   $33,500 $36,900   Land   $84,000 $92,000   Furniture $130,000 $104,000 $125,000 10 Contingent Liability Soren Ltd identified at acquisition date a lawsuit where Soren Ltd was sued by a former supplier with the Fairvalue of: $13,000   Unrecorded Asset Soren Ltd had unrecorded and internally generated Patent with…

Beckett Pumps is a manufacturer of commercial and heavy industrial Pumps

Beckett Pumps is a manufacturer of commercial and heavy industrial Pumps. The firm’s two product lines are called Directlift and Gravity. The primary raw materials are flexible steel sheets, and 23cm x 60cm of plastic sheets. Each Directlift pump requires a 2/3 of a meter and a Gravity pump requires a one metre of steel sheet. Allowing for normal breakage and scrap steel sheet, the company can cut either enough to make four Directlifts or two Gravity pumps from a single steel sheet. Other raw materials are costly and treated as indirect materials. Jo Smith Beckett Pump’s accountant has gathered the following information in preparation for the company’s annual budget for the next year.   Sales in the fourth quarter of…

New Perspectives Excel 2019 | Module 2: SAM Project 1a

Bergamot Urgent Care Clinic Formatting Workbook Text and Data        GETTING STARTED Open the file NP_EX19_2a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_2a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_2a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Jennifer Williams is the business manager at the Bergamot Urgent Care Clinic.…

New Perspectives Excel 2019 | Module 3: SAM Project 1a

Scrub Jay Peripherals Performing Calculations with Formulas and Functions      GETTING STARTED Open the file NP_EX19_3a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_3a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_3a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Danilo Lewellen is an entrepreneur planning to manufacture and market an innovative handheld…

New Perspectives Excel 2019 | Module 4: SAM Project 1a

Alanis Parks Department Analyze and Chart Financial Data        GETTING STARTED Open the file NP_EX19_4a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_4a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_4a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling…

Corporate Reporting (ACC2CRE) – Stuart Ltd commences its operations

Stuart Ltd commences its operations on 1 July 2019. One year after the commencement of its operations (30 June 2020) the entity presents its first Statement of Comprehensive Income and Statement of Financial Position on 30 June 2020. The statements are prepared before considering taxation. The following information is available. Stuart Ltd Statement of Comprehensive Income for the year ended 30 June 2020     $ $ Sales revenue 10,250,000   Cost of Goods Sold   4,650,000   Gross Profit   5,600,000       Expenses:     Salaries and wages 1,050,000   Selling expense 35,000   Administrative expenses 700,000   Provision for doubtful debts 175,000   Warranty expenses 210,000   Long service leave 350,000   Depreciation expense – Plant 560,000…

New Perspectives Excel 2019 | Module 11: End of Module Project 1

Qualey Consulting CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS      GETTING STARTED Open the file NP_EX19_EOM11-1_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_EOM11-1_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_EOM11-1_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Nadia Ivanov is a partner at Qualey Consulting, a consulting firm with headquarters…

New Perspectives Excel 2019 | Module 12: SAM Project 1a

Penta Insurance DEVELOP AN EXCEL APPLICATION      GETTING STARTED Open the file NP_EX19_12a_FirstLastNamexlsm, available for download from the SAM website. Save the file as NP_EX19_12a_FirstLastNamexlsm by changing the “1” to a “2”. If you do not see the .xlsm file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_12a_FirstLastNamexlsm still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. To complete this project, you need to add the Developer tab. If this tab does not display, right-click…

New Perspectives Excel 2019 | Module 5: End of Module Project 1

Lewellen Group GENERATE REPORTS FROM MULTIPLE WORKBOOKS        GETTING STARTED Open the file NP_EX19_EOM5-1_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_EOM5-1_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer: Support_EX19_EOM5-1_2021.xlsx With the file NP_EX19_EOM5-1_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file…

 New Perspectives Excel 2019 | Module 7: End of Module Project 1

Pierce Software SUMMARIZE DATA WITH PIVOTTABLES      GETTING STARTED Open the file NP_EX19_EOM7-1_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_EOM7-1_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_EOM7-1_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Tiana Morales is the director of the customer call center for Pierce Software. For the past…

New Perspectives Excel 2019 | Module 6: End of Module Project 1

Veritate Online MANAGE YOUR DATA WITH DATA TOOLS      GETTING STARTED Open the file NP_EX19_EOM6-1_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_EOM6-1_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_EOM6-1_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Padma Laghari is a content manager for Veritate Online, a website that sells electronics,…