Chapter 6, Problem 2P

Compute the tax liability of both companies on these financial accounting question

Regal Properties (RP) just acquired land and a building for a single sum of $500,000. An independent appraisal determined the fair values of the assets (if purchased separately) at $350,000 for the land and $250,000 for the building. Prepare the journal entry in table format to record the purchase of the land and building.

You work for a beverage company that sells coffee and tea. Your boss has asked you to help set up thecompany’s new database using Microsoft Access and then perform some queries in Access to determineinformation that your boss needs to give to the senior management. You are given a flat file(Beverage_Co_Sp25.xls) with the company’s sales information. When you open the file, you notice that it is notset up in efficient tables. You must create efficient tables in Excel before importing the data into MicrosoftAccess. Then, you need to run queries to gather the information your boss needs.Excel InstructionsYou will need to create 5 efficient tables from the one worksheet in the Excel file you have been given:Customers, Employees, Sales, Inventory, and SalesItems. You will need to determine which columns need to beincluded in each table and delete any duplicates and blank rows in the tables.Furthermore, once you have created the Sales table, make sure to change the name of the…