Prepare an unadjusted trial balance from the spreadsheet

Assignment Help Finance Basics
Reference no: EM131097336

1. The company purchased $7,500,000 of raw material inventory on account. "On account" means that their suppliers have not yet been paid. That is, Mountain View Manufacturing Company has an additional "Account Payable" for the inventory purchase.

2. During the year, the company incurred $6,000,000 of factory wages. When wages relate to the production of a company's inventory, the wage costs are added to the inventory account. For now, assume that the wages have not been paid.

3. The company sold in inventory that cost $14,000,000 for a total of $22,000,000. Of that, $17,000,000 was received in cash and $5,000,000 was on account (that is, added to accounts receivable).    

4. The company paid $8,200,000 to suppliers for inventory it had previously purchased on account. That is, it paid $8,200,000 of accounts payable.

5. The company collected $4,100,000 of accounts receivable.

6. The company incurred sales and marketing expenses of $1,505,431, general and administrative expenses of $2,044,569, and retail operating expenses of $1,750,000. They paid $2,000,000 in cash and $3,300,000 was added to other accrued expenses.

7. The company paid $6,423,789 to employees for wages that had been previously accrued.

8. Mountain View Manufacturing Company received $125,000 in cash from new franchisees. The company must provide services to the franchisees over the next five years. As such, the fees are considered deferred income.

9. The company paid $498,832 for new property and equipment.

10. During the year, the company declared $2,407,167 of dividends on its common shares. They paid $2,403,458 doting the fiscal year. The difference, $3,709, will be paid in the following fiscal year.

11. Many other transactions were recorded during the year. They are summarized in the spreadsheet.

Required-

a. Prepare journal entries for No.  1 ~ 10, as needed, for each of the above fiscal 2013 "transactions". You should include explanations. All figures are in thousands of dollars.

b. Post the journal entries for the transactions to the spreadsheet. (You have to make your own spreadsheet.)

c. Prepare an unadjusted trial balance from the spreadsheet. (Hint: the unadjusted balance for retained earnings in $3,343,850.)

d. Prepare journal entries for the following adjustments, No. 12 ~ 15. You should include explanations.   

12. Mountain View Manufacturing Company employees took a physical count of inventory on February 29, 2016. The cost of inventory in the company's possession on that date was $3,281,447.

13. Depreciation and amortization expense on property and equipment was $698,580 for the fiscal year.

14. At year end, the company determined that $646,156 of wages were earned but remained unpaid. Of that total, $639,200 relates to general and administrative expenses and $6,956 relates to retail operating expenses.

15. In February 2016, a consulting firm hired by Mountain View Manufacturing Company issued a report stating that the "Mountain View Manufacturing" brand name is worth $500,000.

e. Post the journal entries for the adjustments to the spreadsheet and complete the pre-closing trail balance column.

f. Prepare an income statement for the year ended February 29, 2016.

g. Prepare the closing entries and close all the temporary accounts on the income statement to Retained earnings. You should include explanations. Complete the post- closing (ending) balance column. Verify that the amounts for the balance sheet accounts in the post-closing balance column match the amounts in the actual February 29, 2016 financial statement column.

h. Prepare the February 29, 2016, balance sheet.

Attachment:- Assignment.rar

Reference no: EM131097336

Questions Cloud

What effective annual interest rate is she paying : A woman went to the Bene?cial Loan Company and borrowed $9000. She must pay $350 at the end of each month for the next 30 months. What is the monthly interest rate she is paying? What effective annual interest rate is she paying?
Law graduates enter lucrative large firm law practices : New York University is one of the most “liberal” law schools in the country. However, in spite of the political leanings of the faculty and the students, the vast majority of its law graduates enter lucrative large firm law practices, not public inte..
Communicate depends on age or generation : Do you believe the way leaders communicate depends on their age or generation? Explain why you agree or disagree with this statement and /or at least one of the readings. Practice using in-text citations for the article(s) as you write your respon..
Calculate the equilibrium price and quantity in the market : Market research has revealed the following information about the market for chocolate bars: The demand schedule can be represented by the equation Qd = 1.600 - 300P. where Qd is the quantity demanded and P is the price. Calculate the equilibrium pric..
Prepare an unadjusted trial balance from the spreadsheet : The company purchased $7,500,000 of raw material inventory on account. "On account" means that their suppliers have not yet been paid. Prepare an unadjusted trial balance from the spreadsheet
Perfectly price discriminating monopolist : Which of the following statements is true with respect to a market in which there is a perfectly price discriminating monopolist?
Settlement balances and on the overnight interest rate : Suppose that there is a net government disbursement of $80 (i.e., the government’s payments to the public exceed its receipts from the public by $80). In the absence of any offsetting transactions by the Bank of Canada, explain the effects of this ne..
Summary on:the political dynamics of higher education policy : Write a summary of the following Article: The Political Dynamics of Higher Education Policy.
Determine the equivalent stress in the cylinder : Determine the maximum shear stress at the outer surface of the cylinder.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd