Produce a balance sheet for a company that distinguishes betweencurrent and non- current assets and liabilities.
Create a balance sheet from a trial balance.
Create a comparison of net income based on different methods ofinventory accounting.
Analyze a statement of cash flows and show where each line itemcan be found or
calculated from the other financial statements.
Prepare a full analysis of key financial ratios for a companyand state conclusions about
the financial strength of the company compared to industryratios.
PROJECT SUBMISSION PLAN
Project Part
Description/Requirements of Project Part
Evaluation Criteria
1
Title: Creating a Balance Sheet and Evaluating Inventory
You will be provided with financial information about a fictionalcompany. You will have to determine what information is relevantfor Project Parts 1 and 2.
Task 1: Create a balance sheet from a trial balance for a givenscenario. Make sure you classify the accounts appropriately ascurrent or non-current. Click here to download the trialbalance.
Page 1
AC1420: Project
Project Part
Description/Requirements of Project Part
Evaluation Criteria
Task 2: Perform inventory valuations using LIFO, FIFO, andweighted average methods based on the following information.Explain the impact of each method on the cost of goods sold andending inventory.
The company imports microwaves from a supplier in China for theUS market. At the end of the first quarter, 100 microwaves are instock. The company purchased a total of 400 microwaves during thequarter at various prices: January: 100 units @ $75
February: 250 units @ $83
March: 50 units @ $87
The company had no inventory at the beginning of the quarter.
Task 3: If the companyâs goal is to maximize net income, whichevaluation method will you use and why?
Project Part 1 -Task 2: Purchases Cost per Unit Total Cost January February March Ending Inventory = Value of Ending Inventory of100 Units Weighted AVG LIFO FIFO Cost of Goods Sold (300 UnitsSold) Weighted AVG LIFO FIFO Create a BalanceSheet from the trial balance: Debits Credits Classification Cash 300,000.00 Current asset Sales (10,000,000.00) Income statement Cost of Goods Sold 7,000,000.00 Income statement Selling Expenses 500,000.00 Income statement Other income (50,000.00) Income statement Administrative expenses 350,000.00 Income statement Interest Expenses 12,500.00 Income statement Land 300,000.00 non-current asset Building 2,000,000.00 non-current asset Long Term bond payable (550,000.00) non-current liability Accrued Liabilities (50,000.00) current- liability Accumulated Depreciation Buildings (250,000.00) non-current asset Equipment 750,000.00 non-current asset Receivables 100,000.00 current asset Allowance for doubtful accounts (7,500.00) current asset Accumulated depreciation equipment (125,000.00) non-current asset Common Stock (200,000.00) equity Payables (115,000.00) current Liability Inventories 200,000.00 current asset Prepaid Expenses 50,000.00 current asset Retained Earnings (215,000.00) equity 11,562,500.00 (11,562,500.00)
Assets Equity and Liabilities Current Assets Current Liabilities Total Current Assets - Total Current Liabilities - Total long term Liabilities - Total property plant andequipment - Total Equity - Total Assets - Total Equity and liabilities -
Produce a balance sheet for a company that distinguishes betweencurrent and non- current assets and liabilities.
Create a balance sheet from a trial balance.
Create a comparison of net income based on different methods ofinventory accounting.
Analyze a statement of cash flows and show where each line itemcan be found or
calculated from the other financial statements.
Prepare a full analysis of key financial ratios for a companyand state conclusions about
the financial strength of the company compared to industryratios.
PROJECT SUBMISSION PLAN
Project Part | Description/Requirements of Project Part | Evaluation Criteria |
1 | Title: Creating a Balance Sheet and Evaluating Inventory Task 1: Create a balance sheet from a trial balance for a givenscenario. Make sure you classify the accounts appropriately ascurrent or non-current. Click here to download the trialbalance. |
Page 1
AC1420: Project
Project Part | Description/Requirements of Project Part | Evaluation Criteria | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 2: Perform inventory valuations using LIFO, FIFO, andweighted average methods based on the following information.Explain the impact of each method on the cost of goods sold andending inventory. The company imports microwaves from a supplier in China for theUS market. At the end of the first quarter, 100 microwaves are instock. The company purchased a total of 400 microwaves during thequarter at various prices: January: 100 units @ $75 February: 250 units @ $83
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Related questions
Produce a balance sheet for a company that distinguishes betweencurrent and non- current assets and liabilities.
Create a balance sheet from a trial balance.
Create a comparison of net income based on different methods ofinventory accounting.
Analyze a statement of cash flows and show where each line itemcan be found or
calculated from the other financial statements.
Prepare a full analysis of key financial ratios for a companyand state conclusions about
the financial strength of the company compared to industryratios.
PROJECT SUBMISSION PLAN
Project Part | Description/Requirements of Project Part | Evaluation Criteria |
1 | Title: Creating a Balance Sheet and Evaluating Inventory Task 1: Create a balance sheet from a trial balance for a givenscenario. Make sure you classify the accounts appropriately ascurrent or non-current. Click here to download the trialbalance. |
Page 1
AC1420: Project
Project Part | Description/Requirements of Project Part | Evaluation Criteria |
| Task 2: Perform inventory valuations using LIFO, FIFO, andweighted average methods based on the following information.Explain the impact of each method on the cost of goods sold andending inventory. The company imports microwaves from a supplier in China for theUS market. At the end of the first quarter, 100 microwaves are instock. The company purchased a total of 400 microwaves during thequarter at various prices: January: 100 units @ $75 February: 250 units @ $83 support your answer with facts. |
1. Produce a balance sheet for a company that distinguishesbetween current and non-current assets and liabilities.
2. Create a balance sheet from a trial balance.
3. Create a comparison of net income based on different methods ofinventory accounting.
4. Analyze a statement of cash flows and show where each line itemcan be found or calculated from the other financialstatements.
5. Prepare a full analysis of key financial ratios for a companyand state conclusions about the financial strength of the companycompared to industry ratios.
| Create a BalanceSheet from the trial balance: | ||||
| Debits | Credits | Classification | ||
| Cash | 300,000.00 | Current asset | ||
| Sales | (10,000,000.00) | Income statement | ||
| Cost of Goods Sold | 7,000,000.00 | Income statement | ||
| Selling Expenses | 500,000.00 | Income statement | ||
| Other income | (50,000.00) | Income statement | ||
| Administrative expenses | 350,000.00 | Income statement | ||
| Interest Expenses | 12,500.00 | Income statement | ||
| Land | 300,000.00 | non-current asset | ||
| Building | 2,000,000.00 | non-current asset | ||
| Long Term bond payable | (550,000.00) | non-current liability | ||
| Accrued Liabilities | (50,000.00) | current- liability | ||
| Accumulated Depreciation Buildings | (250,000.00) | non-current asset | ||
| Equipment | 750,000.00 | non-current asset | ||
| Receivables | 100,000.00 | current asset | ||
| Allowance for doubtful accounts | (7,500.00) | current asset | ||
| Accumulated depreciation equipment | (125,000.00) | non-current asset | ||
| Common Stock | (200,000.00) | equity | ||
| Payables | (115,000.00) | current Liability | ||
| Inventories | 200,000.00 | current asset | ||
| Prepaid Expenses | 50,000.00 | current asset | ||
| Retained Earnings | (215,000.00) | equity | ||
| 11,562,500.00 | (11,562,500.00) | |||
| Assets | Equity and Liabilities | |||||||||
| Current Assets | Current Liabilities | |||||||||
| Total Current Assets | - | Total Current Liabilities | - | |||||||
| Total long term Liabilities | - | |||||||||
| Total property plant and equipment | - | |||||||||
| Total Equity | - | |||||||||
| Total Assets | - | Total Equity and liabilities | - | |||||||
Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December 31, 2016. Follow the instructions below to access each companyâs information and perform a financial analysis based on the financial measures we have learned in this course.
Select Http://www.yahoo.com/ and then select Finance. In the Search section at the top of the screen select KO for Coca-Cola and PEP for Pepsi
Select âFinancialsâ and select Income Statement when accessing the Income Statement
Select âFinancialsâ and select Balance Sheet when accessing the Balance Sheet
Do the following for KO and PEP for the year ended 12/31/16 only
Perform a vertical analysis of the Income Statement for KO and PEP for the year ended 12/31/16.
Include in your vertical analysis all of following as a % of total revenue:
Cost of Revenue as a % of Total Revenue
Gross Profit as a % of Total Revenue
Selling, gen and administrative expenses as a % of Total Revenue
Operating Income as a % of Total Revenue
Net Income as a % of Total Revenue
Current Ratio
Accounts Receivable turnover. Assume the total revenue on the income statement represents all sales on account for the year
Average collection period
Merchandise Inventory turnover. Assume the Cost of Revenue on the Income Statement is the same as the Cost of Goods Sold
Debt to Asset Ratio
Return on Assets Ratio
Asset Turnover
In preparing the vertical analysis and other financial analysis above; define each measure and identify the strengths and weaknesses of KO and PEP as related to each other. Below is an example of you should set it up.
| Working Capital | KO | PEP |
| Current Assets | $ 34,010,000 | $ 27,089,000 |
| - Current Liabilities | $ 26,532,000 | $ 21,135,000 |
| Net Working Capital = | $ 7,478,000 | $ 5,954,000 |
Strength or Weakness
Working Capital measures the ability of a company to meet its short-term obligations with current assets. Pepsi is and Coke are performing at about the same level. Cokes working capital is a little higher because they have higher current assets and current liabilities.
Requirements for Each Group
1.The vertical analysis prepared in 4 A above.
2.All of your computations for the financial analysis. (4 B through 4 H)
3.Identification of strengths and weaknesses. (Include a definition of each financial measure, a description of which company is doing better in each financial measure including the vertical analysis and explain why)
4.All group members must submit the Report Project Team Assessment
5.If the requirements above are not met, points will be deducted from Parts of the group projects.
Enter all requirements on the Group Project Problem 4 Tab.
Submit one set of answers per group for all four problems. Make sure to include each group members name at the top of each spreadsheet.
Each group member should download the Group Team Assessment and evaluate themselves and everyone else in their group. This evaluation should be submitted anonymously.
