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

  What is its price the markets rate of return

An issue of common stock's most recent dividend is $3.75. Its growth rate is 5.0%. What is its price if the market's rate of return is 7.1%?

  If a company wants to increase its reported income by

if a company wants to increase its reported income by manipulating its investment accounts which should it do?a sell

  What is the average accounting return

The projected net income from the project is $1,000, $1,200, $1,700, and $1,900 a year for the next four years, respectively. What is the average accounting return.

  We learn from gorton that it is not possible to prove

We learn from Gorton that it is not possible to prove that had Lehman Brothers been bailed out by the government or the Federal Reserve the financial crisis of 2008 would not have occurred. This is an example of not being able to prove the "counterfa..

  The bond pays 60 per year interest and is selling in the

a convertible bond has a face value of 1000 and the conversion price is 50 per share. the stock is selling at 42 per

  Management of current assets and current liabilities

The management of current assets and current liabilities in the short run can lead to several challenges for the financial manager. What are some of the more common challenges or problems encountered by the firm in this regard, and what are the p..

  Calculation of weighted average cost of capital

The calculation of the Weighted Average Cost of Capital (WACC) is theoretically simple but practically difficult. Discuss.

  If the expected t-bill rate is 5 and the expected inflation

1. explain the interactions among market efficiency capital budgeting and the cost of capital.2. a. give two examples

  Define the appropriate target population and the sampling

define the appropriate target population and the sampling frame in each of the following situationthe manufacture of a

  Is it a good idea to open american fast food restaurants

Is it a good idea to open American fast food restaurants in Disney parks overseas selling the same kind of food sold in U.S. parks? Why or why not?

  Two doors down inc has weekly credit sales or 44500 and

two doors down inc. has weekly credit sales or 44500 and the average collection period is 25 days. what is tdds

  Find the characteristic of managerial accounting

The president of Warren Manufacturing Company is paid an incentive bonus that is equal to 5 percent of net income. During the current accounting period,

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