Create and convert to excel a profit and loss budget

Assignment Help Accounting Basics

Reference no: EM131473871

Complete the following attached information for Quickbooks 2015.

Part I

Set up a new company in QuickBooks using the following information. (Reminder: Save your company file to the location specified by your instructor. Use the filename: [your name] Comp Exam 2)

On January 1, 2021, you establish a retail store that specializes in flower arrangements and floral services.

Part II

Record the following transactions in QuickBooks for the new company. Reminder: Print your company name on all checks.

Assume the following rates for payroll withholdings.

Part III

Complete all tasks below. Convert all applicable reports to Excel.

1. Run the payroll summary report as of 01/31/2021.

2. Run the Unadjusted Trial Balance at January 31, 2021. Convert to Excel and submit

3. Make the following adjusting entry:

a. Industrial Refrigerator depreciation expense is $75 per month.

4. Print the following reports using QuickBooks. Convert to Excel and Submit to your Instructor:

a. Journal from January 1, 2021 to January 31, 2021.

b. Adjusted Trial Balance at January 31, 2021.

c. Profit and Loss, standard, from January 1,2021 to January 31, 2021.

d. Balance Sheet, standard, at January 31, 2021.

e. Statement of Cash Flows for January 1, 2021 to January 31, 2021.

f. Customer Balance Detail for January 1, 2021 to January 31, 2021.

g. Chart of accounts.

h. Vendor Balance Detail

5. Create and convert to Excel a Profit and Loss Budget for 2021 based on the following information.

a. January projected merchandise sales: $400

b. Monthly expected sales increase: 3% (compounding)

c. Monthly rent increase: 1% (compounding, January's rent $200)

Attachment:- Assignment File.rar

Reference no: EM131473871

Questions Cloud

What will your monthly payments be : You have arranged to finance the remaining $130,000 with a 30-year, monthly payment, amortized mortgage at a 6% nominal annual interest rate

Discuss why this is relevant in a module about ipos : Consider this case and other examples of alleged insider trading or other corporate malfeasance. Discuss why this is relevant in a module about IPOs.

Review the case of anderson v owens corning fiberglas corp : FACTS Carl Anderson filed a suit in strict liability against Owens-Corning Fiberglas Corp. and other manufacturers of products containing asbestos.

Difference between systematic and unsystematic risk : Explain the difference between systematic and unsystematic risk, and why one of these types of risks is rewarded with a risk premium while the other type is not

Create and convert to excel a profit and loss budget : Create and convert to Excel a Profit and Loss Budget for 2021 based on the following information: January projected merchandise sales: $400

Does the piece reflect your distinct voice : What material was presented in this milestone's objectives or discussion that was new information to you and how will it help you?

Consider the prevailing conditions for inflation : Consider the prevailing conditions for inflation (including oil prices), the economy, interest rates, and any other factors that could affect exchange rates.

How many people in the us have dog : How many people in the U.S have dog, and the estimated demand for dog walkers gallup statistics. In us around 44% of the population own dogs and 29% own cats.

Compared to the fdx call option above : Compared to the FDX call option above with another FDX call option with an exercise price of $190 and a premium of $1. What might an investor who prefers.

Reviews

len1473871

4/25/2017 7:15:43 AM

Complete the following attached information for Quickbooks 2015. This is for ACNT 1313. Would prefer a quickbook file to download my own reports if possible. Set up a new company in QuickBooks using the following information. (Reminder: Save your company file to the location specified by your instructor. Use the filename: [your name] Comp Exam 2)

Write a Review

Required(*) Message

User Account

All Pages