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

  Calculating multiple cash flows for a year

Calculating multiple cash flows for a year and determine the amount of each of the annual annuity payment

  List some common forms of business organization and discuss

list some common forms of business organization and discuss how access to capital differs across these forms of

  Suppose the beta of a firms assets is k and the tax rate

suppose the beta of a firms assets is k and the tax rate is 40. what is the debt-to-equity ratio if the beta of the

  Is exchange rate risk relevant list some pros and cons and

is exchange rate risk relevant? list some pros and cons and tell us your informed opinion this assignment should be

  What foreign exchange intervention is necessary to maintain

Under fixed exchange rates, if Britain becomes more productive relative to the US, what foreign exchange intervention is necessary to maintain the fixed exchange rate between dollars and pounds? By whom?

  What is the yield-to-maturity

Soo Lee Imports issued 17-year bonds 2 years ago at a coupon rate of 10.3 percent. The bonds make semiannual payments. These bonds currently sell for 102 percent of par value. What is the yield-to-maturity? Show the work for a calculator.

  Evaluate the effective annual interest rate associated

Credit standards and accounts receivable Evaluate the effective annual interest rate associated with loan

  Security of equal risk

The security lasts for 10 years. Another security of equal risk also has a maturity of 10 years, and pays 10 percent compounded monthly (that is, the nominal rate is 10 percent). What should be the price of the security that you just purchased?

  Companies are sometimes able to show very rapid growth in

companies are sometimes able to show very rapid growth in eps over a few years. this often gets investors interested

  Scenario from the university of phoenix material

Define activities for a project based on the scenario you choose. You must include the following: Identify the scope of the project.

  What is the internal rate of return for this project

The net working capital will return to its original level when the project ends. The tax rate is 35 percent. What is the internal rate of return for this project?

  Determine the market value of the operation ignoring taxes

an oil company has paid 100000 for the right to pump oil on a plot of land during the next three years. a well has

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