Question

In: Accounting

Please prepare a trial balance using the information given. You have been hired as an accountant...

Please prepare a trial balance using the information given.

You have been hired as an accountant for NFT Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together. The business was created on November 1, 2017. The company will have a fiscal year end of October 31st.   The initial formation transactions and early purchases for NFT Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet. (see the worksheet tab)

During November, the first month of operations, the following transactions occurred:
Date Event
1-Nov Paid $7,200 for 12 months rent on office space
2-Nov Purchased office furniture for $8,950.  
3-Nov Purchased $11,354 of additional office supplies on account.
8-Nov Borrowed 20,000 from the bank for operating cash. The note has a 3% interest rate (simple interest) and is to be paid back in 4 years
15-Nov Received $10,800 from Fortuna Inc. for work to be performed over the next 12 months.
20-Nov Paid $1,560 for utilities.
21-Nov Performed services for various customers for $13,200 cash and another $18,100 on account.  
25-Nov Paid $8,650 for purchases of supplies previously made on account.
27-Nov Paid salaries to employees totaling $5,200 for 1 week.
30-Nov Collected $12,300 as payment for amounts previously billed.
30-Nov Dividends of $3,000 were declared and paid.
At the end of November, the following additional information is available to help determine what adjustments are needed:
30-Nov One month of the prepaid rent has been used up
30-Nov Supplies on hand are $8,150.
30-Nov One month of interest has accrued on the note payable for the bank loan.
30-Nov One month of the services for the Fortuna Inc. has been performed (see above).
30-Nov Salaries of $5,200 are paid every Friday (for a 5 day work week). November 30, 2017 was a Thursday.
30-Nov Additional work for customers of $9,580 has been performed during the last week of November but not yet billed
30-Nov Depreciation expense for the computer equipment is $140 and for the office furniture is $120
Worksheet - NFT Consulting Inc
BEGINNING NUMBERS November ENTRIES UNADJUSTED TRIAL BALANCE ADJUSTMENTS ADJUSTED TRIAL BALANCE
ACCOUNT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT
Cash         221,400
Accounts Receivable
Supplies             8,650
Prepaid Rent
Land           40,000
Computer Equipment           38,600
Accumulated Depreciation, Comp Equip
Office Furniture
Accumulated Depreciation, Off Furn
Accounts Payable             8,650
Salaries Payable
Interest Payable
Unearned Revenue
Long-term Notes Payable
Common Stock         300,000
Retained Earnings
Dividends
Service Revenue
Salaries Expense
Rent Expense
Supplies Expense
Maintenance Expense
Utilities Expense
Interest Expense
Depreciation Expense, Comp Equip
Depreciation Expense, Office Furniture
        308,650         308,650

Solutions

Expert Solution

BEGINNING NUMBERS November ENTRIES UNADJUSTED TRIAL BALANCE ADJUSTMENTS ADJUSTED TRIAL BALANCE
ACCOUNT DEBIT CREDIT DEBIT CREDIT   DEBIT     CREDIT     DEBIT     CREDIT     DEBIT     CREDIT  
Cash        2,21,400       56,300       34,560    2,43,140    2,43,140
Accounts Receivable       18,100       12,300         5,800         9,580       15,380
Supplies               8,650       11,354       20,004       12,034         7,970
Prepaid Rent         7,200         7,200            600         6,600
Land           40,000       40,000       40,000
Computer Equipment           38,600       38,600       38,600
Accumulated Depreciation, Comp Equip               -              140            140
Office Furniture         8,950         8,950         8,950
Accumulated Depreciation, Off Furn               -              120            120
Accounts Payable           8,650         8,650       11,354       11,354       11,354
Salaries Payable               -           4,160         4,160
Interest Payable               -              600            600
Unearned Revenue       10,800       10,800            900         9,900
Long-term Notes Payable       20,000       20,000       20,000
Common Stock        3,00,000    3,00,000    3,00,000
Retained Earnings         3,000         3,000         3,000
Dividends               -                 -  
Service Revenue       31,300       31,300       10,480       41,780
Salaries Expense         5,200         5,200         4,160         9,360
Rent Expense               -              600            600
Supplies Expense               -         12,034       12,034
Maintenance Expense               -                 -  
Utilities Expense           1,560         1,560         1,560
Interest Expense               -              600            600
Depreciation Expense, Comp Equip               -              140            140
Depreciation Expense, Office Furniture               -              120            120
       3,08,650      3,08,650    1,20,314    1,20,314    3,73,454    3,73,454       28,134       28,134    3,88,054    3,88,054

Related Solutions

Please prepare a closing journal entry using the information given. You have been hired as an...
Please prepare a closing journal entry using the information given. You have been hired as an accountant for NFT Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together. The business was created on November 1, 2017. The company will have a fiscal year end of October 31st.   The initial formation transactions and early purchases for NFT Consulting Inc. resulted in the balances that are included...
As a newly hired management accountant, you have been asked to prepare a profit plan for...
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analyses. Following is the budgeted information regarding the coming year: Selling price per unit $ 100.00 Variable cost per unit 70.00 Fixed costs (per year) 1,200,000 Required: 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal...
As a newly hired management accountant, you have been asked to prepare a profit plan for...
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analysis. Following is the budgeted information regarding the coming year: Selling price per unit $ 100.00 Variable cost per unit 70.00 Fixed costs (per year) 1,200,000. 1)What is the breakeven volume, in units, for the coming year? 2) Assume that of the $70 variable cost per...
PLEASE ANSWER ASAP IF POSSIBLE!!! 7. You have been hired as the accountant for a newly...
PLEASE ANSWER ASAP IF POSSIBLE!!! 7. You have been hired as the accountant for a newly formed real estate company called Antsy Real Estate Limited. The following business transactions occurred during the month of September, 2022: 1.    Shareholders invested $35,000 in cash for 35,000 common shares to start the corporation. 2.    Signed a lease for office space, at $9,500 per year for five years. 3.    Paid $250 cash for supplies. 4.    Purchased equipment for $12,000, paying $7,000 in cash and...
Item1 Item1 Item 1 As a newly hired management accountant, you have been asked to prepare...
Item1 Item1 Item 1 As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analyses. Following is the budgeted information regarding the coming year: Selling price per unit $ 100.00 Variable cost per unit 70.00 Fixed costs (per year) 1,200,000 Required: 1. What is the breakeven volume, in units and dollars, for the coming year? 2....
Please prepare a full trial balance – Trial Balance, Adjustments,Adjusted Trial Balance, Income Statement, Balance...
Please prepare a full trial balance – Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet, and Statement of Owner’s Equity, as well the individual Balance Sheet, Income Statement, and Statement of Owners Equity. Include any journal entries necessary for this assignment. Use T accounts if you find them helpful. Attached are the files for your use. Check your formulas. 1. You are reporting for your client for the One Month period September 30, 2020 2. The started the...
You have been hired as an expert witness by an attorney for a trial involving a...
You have been hired as an expert witness by an attorney for a trial involving a traffic accident. The attorney's client, the plaintiff in this case, was traveling eastbound toward an intersection at 13.2 m/s as measured just before the accident by a roadside speed meter, and as seen by a trustworthy witness. As the plaintiff entered the intersection, his car was struck by a northbound driver, the defendant in this case, driving a car with identical mass to the...
You have been hired as an expert witness by an attorney for a trial involving a...
You have been hired as an expert witness by an attorney for a trial involving a traffic accident. The attorney's client, the plaintiff in this case, was traveling eastbound toward an intersection at 13.8 m/s as measured just before the accident by a roadside speed meter, and as seen by a trustworthy witness. As the plaintiff entered the intersection, his car was struck by a northbound driver, the defendant in this case, driving a car with identical mass to the...
You have recently been hired as a cost accountant at Travenol Laboratories. The controller is an...
You have recently been hired as a cost accountant at Travenol Laboratories. The controller is an "old school" accountant and has heard that you recently graduated with a degree in accounting. One day he summons you to his office to assign you a task. He says, "I understand that recently educated accountants are using a variety of statistical tools to determine causality between costs and their respective drivers. We have been using direct labor hours as our cost driver for...
You have been hired as a staff accountant by a small company that recently completed an...
You have been hired as a staff accountant by a small company that recently completed an initial public offering (IPO) of its common stock. At its inception, the company had been financed by Pegasus, an investment group. Pegasus had bought a significant amount of the company’s debt (equal to a third of its total assets) in the form of convertible bonds. The stock price has appreciated significant since the IPO, and Pegasus has decided to convert its debt securities into...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT