Question: create individual ledgers for years 1 and 2. Then create a balance sheet, income statement, and statement of stockholders Equity separately for both years 1

create individual ledgers for years 1 and 2. Then create a balance sheet, income statement, and statement of stockholders Equity separately for both years 1 and 2. create these in excel and please provide formulas used as well.
3 4 5 6 Post transactions to the Ledger for the corresponding year (using formulas) Calculate amounts for December 31 adjustm

Year 1 Given Information $ 697,544 153,460 6,801 15,346 30,552 558,035 1-Jan Issued common stock in exchange for cash 1-Feb B

December 31st Adjustments: a Eleven months of interest has accrued on the note (to be paid in cash on Feb 1 next year) b Nine

Given Information $ 31,389 Year 2 15-Jan Paid employees for one month of work 1-Feb Paid back the note payable in full, plus

December 31st Adjustments: a b С Remaining three months of one-year insurance policy were used up A physical count of supplie

Balance Sheet Assets Liabilities Stockholders Equity Accounts Receivable Prepaid Insurance Running. Prepaid Rent Unearned Ser

Balance Sheet Income Statement Statement of Stockholdnt Cash Cassapanes Plus Stock Accounts Receivable Ending Common Stock A

3 4 5 6 Post transactions to the Ledger for the corresponding year (using formulas) Calculate amounts for December 31 adjustments in yellow boxes (using formulas) Post adjustments to the Ledger for the corresponding year (using formulas) Prepare the following financial statements (using formulas) for the corresponding year: (a) Balance Sheet (b) Income Statement (c) Statement of Stockholders' Equity

Step by Step Solution

★★★★★

3.40 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Weve just processed all our transactions into journals The next step in the accounting process is entering these journal entries into ledgers What is a Ledger Ledger is a summary of transactions that ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Attached are the income statement and statement of stockholders equity for Varney Corp for the year ended 12/31/2014 and the comparative balance sheet information at 12/31/2013 and 12/31/2014. The...

Problem I (20 points): Given the assumptions from 2013 to 2015, please assume that the financial ratios in 2016 is the average of those of the first three years, answer the following questions....

Antioch Company makes eBook readers. The company had the following amounts at the beginning of 2018: Cash, $677,000; Raw Materials Inventory, $65,000; Work in Process Inventory, $33,000; Finished...

Determining Financial Statement Effects of Adjusting Entries Refer to P4-2. Required: 1. Indicate whether each transaction relates to a deferred revenue, deferred expense, accrued revenue, or accrued...

Using the following categories, indicate the effects of the transactions listed in M12-3 assuming the securities are trading securities. Use + for increase and for decrease and indicate theamounts....

A light-hydrocarbon feed stream contains 45.4 kmol/h of propane, 136.1 kmol/h of isobutane, 226.8 kmol/h of n-butane, 181.4 kmol/h of isopentane, and 317.4 kmol/h of n-pentane. This stream is to be...

The December 31, 2011, balances in retained earnings and additional paid-in capital for Railway Shippers Company are $135,000 and $50,000, respectively. Five thousand $10 par value common shares are...

Pearcy Company reports the following activity during October related to its inventory of cameras: Oct. 1 Beginning inventory consisted of 8 cameras costing $100 each. 3 Purchased 12 cameras costing...

The network of Fig. 5-37 uses RSVP with multicast trees for hosts 1 and 2 as shown. Suppose that host 3 requests a channel of bandwidth 2 MB/sec for a flow from host 1 and another channel of...

Quoton Corporation acquired 80 percent of Tempro Companys common stock on December 31, 20X5, at underlying book value. The book values and fair values of Tempros assets and liabilities were equal,...

Location A Location B 844 233 200 200 167 410 300 675 475 350 250 370 950 175 179 350 880 345 Paired T-Test and Cl: Location A, Location B Two-Sample T-Test and CI: Location A, Location B Descriptive...

811 3 4 5 XVfx A B C D E G MCO Leather manufactures leather purses. Each purse requires 2 pounds of direct materials at a cost of $4 per pound and 0.8 direct labor hours at a rate of $16 per hour....

. The Skills Model of leadership outlines three "skills" needed for top management, middle management and supervisory management. Describe the three skills and explain when they are needed in the...

5. Consider the language, L, using the alphabet A = {a, , y} defined by: a word w is in L if and only if the number of a's times the number of 's equals the number of y's. So yaay is in L but ayayy...

Kohler Corporation reports the following components of stockholders' equity at December 31 of the prior year. Common stock-$20 par value, 100,000 shares authorized, 50,000 shares issued and...

Assessment Instructions 1. Answer the following four questions: i. What are your career goals? ii. What are you really good at professionally? iii. What are you not good at or not interested in doing...

Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: \ table [ [ March , 7 , 0 0 0 ] , [ April , 9 , 0 0 0 ] , [ May , 6 , 5 0 0 ] , [ June , 5 , 0 0 0 ] ]...

What is beacon marketing? What are digital wallets?

Which do you think are the two or three most important financial ratios? Why?

What is a vertical marketing system? Identify examples of the three types of VMSs.

Is marketing information as important to small firms as it is to larger firms? Explain.

Deanna is paid a base salary plus commission. On sales of $27,000 and $35,500 in two successive months, her gross pay was $2815.00 and $3197.50, respectively. What are her base salary and commission...

The annual net income of the Todd Bros. partnership is distributed so that Ken receives $15,000 more than 80% of Hughs share. How should a net income of $98,430 be divided between the partners?

Albion Distributors revenues and expenses for the fiscal year just completed were $2,347,000 and $2,189,000, respectively. a. If in the current year revenues rise by 10% but expense increases are...