UPDATED ATTACHMENTS – Need help with my ratio analysis memo using the virtual company Riordan Mfg. I have attached my syllabus, grading rubric and pertinent info regarding this company.
Following is instructions from the instructor:
Students, For your Week Nine ratio project, please use the virtual company Riordan Mfg. The company is listed under the business tab of your virtual organizations. After clicking “intranet” in the right hand corner, look for the finance and accounting tab at the top and print the balance sheet and income statement. Students, What I have found is if you go through each ratio on your syllabus/assignment, get the formula and then use the balance sheet and income statement to get your answer. On your excell spreadsheet, I am only looking for the type of ratio, the calculation and the answer. You are not required to put any more than that. On seperate tabs, do the horizontal analysis, vertical analysis, and the memo. Chapter 14 details the formulas for the ratio’s and examples of each. However make sure you complete each ratio, each analysis and the memo. · Liquidity ratios
o
Current ratio
o Acid-test, or quick, ratio
o Receivables turnover
o Inventory turnover
Balance Sheet
Riordan Manufacturing, Inc. | ||||||||||||||||||||||||||||||||||||||
Consolidated Balance Sheet | ||||||||||||||||||||||||||||||||||||||
Fiscal Year Ending September 30th | ||||||||||||||||||||||||||||||||||||||
2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | |||||||||||||||||||||||||||||||
Assets | ||||||||||||||||||||||||||||||||||||||
Current Assets | ||||||||||||||||||||||||||||||||||||||
Cash | $2,807,029 | $1,511,253 | $1,040,639 | $1,442,507 | $1,336,319 | $305,563 | $357,216 | $85,632 | ||||||||||||||||||||||||||||||
Accounts Receivable | $2,695,342 | $2,644,307 | $2,883,964 | $4,544,138 | $4,855,334 | $6,062,838 | $5,657,216 | $6,556,160 | ||||||||||||||||||||||||||||||
Current Portion of Notes Receivable | $102,976 | $117,475 | $107,107 | $109,293 | $95,538 | $70,825 | $117,888 | $13,184 | ||||||||||||||||||||||||||||||
Inventories | $8,517,203 | $7,123,790 | $8,305,690 | $7,919,987 | $7,224,947 | $7,850,970 | $7,854,112 | $8,074,880 | ||||||||||||||||||||||||||||||
Deferred Income Taxes – net | $0 | $328,832 | $349,184 | |||||||||||||||||||||||||||||||||||
Pre-paid Expenses and Other Items | $402,240 | $458,875 | $279,336 | $294,038 | $256,903 | $264,896 | $328,192 | $336,128 | ||||||||||||||||||||||||||||||
Total Current Assets | $14,524,790 | $11,855,700 | $12,616,736 | $14,309,963 | $13,769,041 | $14,555,092 | $14,643,456 | $15,415,168 | ||||||||||||||||||||||||||||||
Notes Receivable, less current portion | $936,168 | $1,067,953 | $1,102,260 | $1,124,755 | $986,627 | $256,583 | $177,408 | $431,104 | ||||||||||||||||||||||||||||||
Investment in Joint Venture | $1,609,004 | $1,333,504 | $1,183,504 | $1,058,504 | $858,504 | $283,504 | $133,504 | $139,136 | ||||||||||||||||||||||||||||||
Property, Plant & Equipment – net | $16,658,218 | $17,767,486 | $18,869,612 | $18,424,594 | $24,510,830 | $19,114,830 | $18,511,360 | $19,205,120 | ||||||||||||||||||||||||||||||
Intangible Assets – net | $904,473 | $550,590 | $329,405 | $395,136 | ||||||||||||||||||||||||||||||||||
Other Assets | $192,845 | $175,314 | $106,721 | $108,899 | $107,821 | $52,768 | $54,400 | $51,840 | ||||||||||||||||||||||||||||||
Total Assets | $34,825,498 | $33,104,430 | $34,429,423 | $35,577,305 | $40,783,413 | $34,592,182 | $33,856,256 | $35,637,504 | ||||||||||||||||||||||||||||||
Liabilities and Stockholders’ Equity | ||||||||||||||||||||||||||||||||||||||
Current Liabilities | ||||||||||||||||||||||||||||||||||||||
Current Portion of Long-Term Debt | $474,032 | $484,894 | $497,480 | $495,515 | $538,046 | $1,219,258 | $1,106,304 | $1,737,728 | ||||||||||||||||||||||||||||||
Accounts Payable | $1,391,385 | $1,636,923 | $1,694,523 | $1,783,708 | $3,930,399 | $3,650,073 | $3,573,248 | $2,676,096 | ||||||||||||||||||||||||||||||
Accrued Liabilities | $524,685 | $617,276 | $638,997 | $631,108 | $1,390,648 | $1,350,144 | $1,257,344 | |||||||||||||||||||||||||||||||
Income Taxes Payable | $359,955 | $99,113 | $243,440 | $855,504 | $1,351,775 | $754,619 | $164,864 | |||||||||||||||||||||||||||||||
Total Current Liabilities | $2,750,057 | $2,838,206 | $3,074,440 | $3,765,835 | $7,210,868 | $6,974,094 | $6,029,696 | $5,836,032 | ||||||||||||||||||||||||||||||
Bank Line of Credit | $295,865 | $477,069 | $598,423 | $109,528 | $100,836 | $253,727 | $487,936 | $245,760 | ||||||||||||||||||||||||||||||
Long-Term Debt – less current portion | $1,006,955 | $1,354,461 | $1,719,851 | $1,926,618 | $2,278,481 | $2,763,752 | $2,535,552 | $4,793,856 | ||||||||||||||||||||||||||||||
$825,629 | $917,366 | $1,067,449 | $2,485,354 | $3,107,072 | $3,283,328 | |||||||||||||||||||||||||||||||||
Total Liabilities | $4,878,506 | $5,587,102 | $6,310,080 | $6,869,430 | $12,075,539 | $12,476,927 | $12,160,256 | $14,158,976 | ||||||||||||||||||||||||||||||
Common Stock (Stated par value is $.01. 20,000,000 shares authorized. Issued and Outstanding 15,801,332 net of treasury shares.) |
$29,055,488 | $29,491,328 | ||||||||||||||||||||||||||||||||||||
Other Accummulated Comprehensive Losses | ($202,496) | ($163,840) | ||||||||||||||||||||||||||||||||||||
Retained Earnings /(Accummulated Deficit) | $891,504 | ($1,538,160) | ($936,145) | ($347,613) | ($347,614) | ($6,940,233) | ($7,156,992) | ($7,848,960) | ||||||||||||||||||||||||||||||
Total Stockholders’ Equity | $29,946,992 | $27,517,328 | $28,119,343 | $28,707,875 | $28,707,874 | $22,115,255 | $21,696,000 | $21,478,528 | ||||||||||||||||||||||||||||||
Total Liabilities and Stockholders’ Equity | ||||||||||||||||||||||||||||||||||||||
© 2005, 2006, 2012 Apollo Group, Inc. All rights reserved. |
Income Statment
Riordan Manufacturing, Inc. | |||||||||||||||||||
Income Statement For the 12 months ending September 30th |
|||||||||||||||||||
Fiscal Year Ending September 30th | |||||||||||||||||||
2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | |||||||||||
Sales | $56,534,254 | $50,468,000 | $61,727,010 | $61,127,960 | $60,642,820 | $50,823,685 | $46,044,288 | $43,418,370 | $39,481,276 | ||||||||||
Direct Cost of Goods Sold | $43,970,250 | $39,345,460 | $48,324,660 | $42,462,480 | $41,843,546 | $42,037,624 | $37,480,050 | $34,517,604 | $30,953,320 | ||||||||||
Gross Margin | $12,564,004 | $11,122,540 | $13,402,350 | $18,665,480 | $18,799,274 | $8,786,061 | $8,564,238 | $8,900,766 | $8,527,956 | ||||||||||
Operating Expenses | |||||||||||||||||||
Sales, Marketing & Other | $1,265,348 | $1,405,942 | $1,528,198 | $1,455,427 | $1,212,856 | $1,012,974 | $920,886 | $1,085,459 | $1,105,476 | ||||||||||
Depreciation | $1,152,125 | $1,144,983 | $1,122,235 | $1,099,378 | $343,445 | $349,937 | $329,980 | $312,612 | |||||||||||
Quality Assurance | $1,112,247 | $1,208,964 | $1,422,311 | $1,376,874 | $1,359,876 | $1,139,688 | $1,095,854 | $1,033,357 | |||||||||||
Research & Development | $962,627 | $1,069,585 | $1,125,879 | $1,093,086 | $1,061,249 | $911,676 | $828,797 | $868,367 | $1,065,994 | ||||||||||
General & Administrative | $4,674,293 | $5,193,659 | $5,770,732 | $5,642,402 | $5,700,306 | $1,706,953 | $1,524,066 | $829,107 | |||||||||||
Machining & Systems | $125,050 | $191,244 | $197,159 | $198,150 | $685,070 | $628,505 | $598,576 | $477,602 | $434,294 | ||||||||||
Total Operating Expenses | $9,291,690 | $10,221,519 | $11,189,262 | $10,888,174 | $11,118,735 | $5,743,241 | $5,318,116 | $4,880,224 | $4,832,942 | ||||||||||
Profit Before Interest & | Taxes | $3,272,314 | $901,021 | $2,213,088 | $7,777,306 | $7,680,539 | $3,042,820 | $3,246,122 | $4,020,542 | $3,695,014 | |||||||||
Non-Operating Expenses | |||||||||||||||||||
Interest Expense | $121,533 | $149,962 | $134,816 | $157,605 | $179,312 | $143,175 | $230,221 | $217,092 | $197,406 | ||||||||||
$719,909 | $198,225 | $486,879 | $1,711,007 | $1,689,719 | $943,274 | $1,025,406 | $1,293,173 | $1,189,186 | |||||||||||
Total Non-Operating Expenses | $841,442 | $348,187 | $621,695 | $1,868,612 | $1,869,031 | $1,086,449 | $1,255,627 | $1,510,265 | $1,386,592 | ||||||||||
Net Profit After Taxes | $2,430,872 | $552,834 | $1,591,393 | $5,908,694 | $5,811,508 | $1,956,371 | $1,990,495 | $2,510,277 | $2,308,422 | ||||||||||
© 2005, 2006, 2012 Apollo Group, Inc. All rights reserved. |
Syllabus XACC/ 2 9 1 Version 1 |
1 |
Syllabus
School of Business XACC/291 Version 1 Principles of Accounting II |
Copyright ©
20
11 by University of Phoenix. All rights reserved.
Course Description
This course introduces accounting concepts in a business environment. Students learn to create and apply accounting documents in making better business decisions. Other topics include plant assets, liabilities, accounting for corporations, investments, statements of cash flows, financial statement analysis, time value of money, payroll accounting, and other significant liabilities.
Policies
Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents:
· University
policies
: You must be logged into the student website to view this document.
· Instructor policies: This document is posted in the Course Materials forum.
University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality.
Course Materials
Weygandt, J. J., Kimmel, P. D., & Kieso, D. E. (2010). Financial accounting (7th ed.). Hoboken, NJ: John Wiley & Sons.
All electronic materials are available on the student website.
Week One: Principle Assets |
||||||||||||||||||||||||||
Details |
Due |
Points |
||||||||||||||||||||||||
Objectives |
1.1 Prepare journal entries to account for transactions related to accounts receivable and bad debt using both percentage of sales and the percentage of receivables methods. 1.2 Distinguish between tangible and intangible assets. |
|||||||||||||||||||||||||
Course Preparation |
Read the course description and objectives. Read the instructor’s biography and post your own. |
|||||||||||||||||||||||||
Reading |
Read Ch. 8 of Financial Accounting. |
|||||||||||||||||||||||||
Read Ch. 9 of Financial Accounting. |
||||||||||||||||||||||||||
Review Ch. 1 of Financial Accounting. |
||||||||||||||||||||||||||
Review Ch. 2 of Financial Accounting. |
||||||||||||||||||||||||||
Review Ch. 3 of Financial Accounting. |
||||||||||||||||||||||||||
Participation/ Discussion |
Participate in class discussion. |
All Week |
2 | |||||||||||||||||||||||
CheckPoint Exercises – Week One |
Resource: Ch. 9 of Financial Accounting Complete Exercise E9-2. Submit as either a Microsoft® Excel® or Word document. |
9/01/13 |
3 |
Week Two: Principle Assets |
||||||
1.3 Identify the entries associated with acquisition, disposal, and sales of plant assets. 1.4 Distinguish between revenue and capital expenditures, and the entries associated with each. |
||||||
CheckPoint Reflection |
Write a 350- to 500-word summary explaining the differences between revenue expenditures and capital expenditures during a useful life and identifying any similarities. Briefly explain the entries of revenue expenditures and capital expenditures. Format your summary consistent with APA guidelines. |
9/3/2013 |
||||
Individual Exercises and Problems – Week Two |
Resource: Ch. 9 of Financial Accounting
Complete Exercises E9-1, E9-7, & E9- 12 . Complete Problem P9-7B. Submit as a Microsoft® Excel® or Word document. |
9/8/2013 |
12 |
Week Three: Liabilities |
1.5 Differentiate among accounts payable, notes payable, and accrued expenses. 1.6 Prepare necessary journal entries to record the issuance of bonds, the periodic interest, and the amortization of bond premiums and discounts. |
Read Ch. 10 of Financial Accounting. |
Week Four: Liabilities |
||
Objective |
1.7 Calculate depreciation and amortization expense using various methods. |
|
Checkpoint Recognizing Differences |
Write a 350- to 500-word paper in which you differentiate between valuation, depreciation, amortization, and depletion. Is it appropriate to calculate depreciation using two different methods? Why? Format your paper consistent with APA guidelines. |
9/18/13 |
Individual Exercises and Problems – Week Four |
Resource: Ch. 10 of Financial Accounting Complete Exercises E10-6, E10-8, & E10-18. Complete Problems 10-3A & 10-6A. Submit as a Microsoft® Excel® or Word document. |
9/22/13 |
Week Five: Equity and Investments |
||
1.8 Differentiate among the types of stocks issued by corporations. |
||
Read Ch. 11 of Financial Accounting. |
||
Read Ch. 12 of Financial Accounting. |
||
Participation/
Discussion |
||
CheckPoint
Stocks |
Write a 250- to 350-word paper explaining why preferred stock is referred to as preferred and what some of the features added to preferred stock are that make it more attractive to investors. Would you select preferred stock or common stock as an investment? Why? Format your paper consistent with APA guidelines. |
9/29/13 |
Week Six: Equity and Investments |
||
1.9 Calculate stocks, dividends, and stock splits. 1.10 Record treasury stock transactions. 1.11 Prepare journal entries associated with the issuance of preferred and common stocks and the declaration and payment of dividends. |
||
CheckPoint
Stocks and Transactions |
Write a response to the following scenario: Chen, Inc. purchases 1,000 shares of its own previously issued $5 per common stock for $12,000. Assuming the shares are held in the treasury, what effect does this transaction have on (a) net income, (b) total assets, (c) total paid-in capital, and (d) total stockholders’ equity? The treasury stock purchased in the above question was resold by Chen, Inc. for $15,000. What effect does this transaction have on (a) net income, (b) total assets, (c) total paid-in capital, and (d) total stockholders’ equity? Format your response consistent with APA guidelines. |
10/02/13 |
Individual
Exercises and Problems – Week Six |
Resources: Ch. 11 & 12 of Financial Accounting Complete Exercises E11-15, E12-1, & E12-2. Complete Problem 11-6A. Submit as a Microsoft® Excel® or Word document. |
10/06/13 |
Week Seven: Financial Statement Analysis |
||
1.12 Prepare a statement of cash flows using both direct and indirect methods. |
||
Read Ch. 13 of Financial Accounting. |
||
Read Ch. 14 of Financial Accounting. |
||
CheckPoint
Cash Flow |
Write a 350-word response to the following: Why are companies required to prepare a statement of cash flows? Why is the statement of cash flows divided into three sections? What does each section tell you about the operations of a company? Format your response consistent with APA guidelines. |
10/13/13 |
Week Eight: Financial Statement Analysis |
||
1.13 Apply ratio, vertical, and horizontal analyses to financial statements. |
||
Nongraded Activities and Preparation Ratio Analysis Memo |
Continue working on the Ratio Analysis Memo assignment due in Week Nine. |
|
CheckPoint
Direct and Indirect Cash Flows |
Write a 350-word response regarding the differences between the direct and indirect presentation of cash flows. Why does the Financial Accounting Standards Board allow both methods? Which do you prefer? Why? Format your response consistent with APA guidelines. |
10/16/13 |
Individual
Exercises – Week Eight |
Resources: Ch. 13 & 14 of Financial Accounting Complete Exercises E13-8 & E14-3. Submit as a Microsoft® Excel or Word® document. |
10/20/13 |
Week Nine: Ethics |
|||
1.14 Identify situations that might lead to unethical accounting practices. 1.15 Examine the effects of unethical behavior and the Sarbanes-Oxley Act on financial statements. |
|||
Read the “Fraud and Internal Control” section in Ch. 7 of Financial Accounting. |
|||
Read Appendix F of Financial Accounting. |
|||
Capstone Discussion Question |
Respond to the capstone discussion question. · Identify situations that might lead to unethical practices and behavior in accounting. Do you think the Sarbanes-Oxley Act has made a difference in the ethical behavior of companies regarding their financial accounting? Why or why not? |
10/23/13 |
|
Final Project Ratio Analysis Memo |
Resources: Virtual Organizations Click the Virtual Organization link on the student website to access the Virtual Organizations. Select one of the Virtual Organizations as the basis for this assignment. Obtain faculty approval of your selected organization before beginning the assignment. Access the information contained in your selected organization’s balance sheet and income statement to calculate the following: · Liquidity ratios Current ratio Acid-test, or quick, ratio Receivables turnover Inventory turnover · Profitability ratios Asset turnover Profit margin Return on assets Return on common stockholders’ equity · Solvency ratios Debt to total assets Times interest earned Show your calculations for each ratio. Create a horizontal and vertical analysis for the balance sheet and the income statement. Write a 350- to 700-word memo to the CEO of your selected organization in which you discuss your findings from your ratio calculations and your horizontal and vertical analysis. In your memo, address the following questions: · What do the liquidity, profitability, and solvency ratios reveal about the financial position of the company? · Which users may be interested in each type of ratio? · What does the collected data reveal about the performance and position of the company? Format your memo consistent with APA guidelines. |
10/27/13 |
20 |
Copyright
University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries.
Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation.
Edited in accordance with University of Phoenix® editorial standards and practices.
Written Assignment Grading Form for Ratio Analysis Memo, Due in Week Nine
Content 60 Percent |
Points Available 13.8 |
Points Earned X/13.8 |
Additional Comments: |
||
· All key elements of the assignment are covered in a substantive way. · Calculates the following aspects using information from the balance sheets and income statements from the selected Virtual Organization: Liquidity ratios · Current ratio · Acid-test, or quick, ratio · Receivables turnover · Inventory turnover Profitability ratios · Asset turnover · Profit margin · Return on assets · Return on common stockholders’ equity Solvency ratios · Debt to total assets · Times interest earned · Show your calculations for each ratio. · Identifies situations that may lead to unethical accounting practices · Examines the effects of Sarbanes-Oxley on financial statements · Prepares at least one question for class discussion · Displays a horizontal and vertical analysis for the balance sheet and income statement · Provides a memo addressing the following questions: · What do the liquidity, profitability, and solvency ratios reveal about the financial position of the company? · Which users may be interested in each type of ratio? · What does the collected data reveal about the performance and position of the company? |
|
||||
Organization / Development 20 Percent |
Points Available 3.1 |
Points Earned
X/3.1 |
|||
· The memo is 350 to 700 words in length. · Paragraph transitions are present, logical, and maintain the flow throughout the paper. · The tone is appropriate to the content and assignment. · Sentences are complete, clear, and concise. · Sentences are well constructed, strong, and varied. · Sentence transitions are present and maintain the flow of thought. |
|||||
Mechanics 20 Percent |
|||||
· The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements. · Intellectual property is recognized with in-text citations and a reference page. · Rules of grammar, usage, and punctuation are followed. · Spelling is correct. |
|||||
Total Available |
Total Earned |
||||
23 |
Riordan Manufacturing, Inc. |
||||||||
|
||||||||
Fiscal Year Ending |
||||||||
2011 |
2010 |
|||||||
Assets |
||||||||
Current Assets |
||||||||
Cash |
$3,725,406 |
$2,807,029 |
||||||
Accounts Receivable |
3,192,094 |
2,695,342 |
||||||
Current Portion of Notes Receivable |
84,255 |
102,976 |
||||||
Inventories |
9,709,611 |
8,517,203 |
||||||
Prepaid Expenses and Other Items |
666,591 |
402,240 |
||||||
Total Current Assets |
$17,377,957 |
$14,524,790 |
||||||
Notes Receivable, less current portion |
$842,551 |
$936,168 |
||||||
Investment in Joint Venture |
1,734,004 |
1,609,004 |
||||||
Property, Plant and Equipment – net |
26,366,949 |
16,658,218 |
||||||
Intangible Assets – net |
904,473 |
|||||||
Other Assets |
183,203 |
192,845 |
||||||
Total Assets |
$47,409,137 |
$34,825,498 |
||||||
Liabilities and Stockholders’ Equity |
||||||||
Current Liabilities |
||||||||
Current Portion of Long-Term Debt |
$1,560,959 |
$474,032 |
||||||
Accounts Payable |
1,141,561 |
1,391,385 |
||||||
Accrued Liabilities |
430,477 |
524,685 |
||||||
Income Taxes Payable |
552,155 |
359,955 |
||||||
Total Current Liabilities |
$3,685,152 |
$2,750,057 |
||||||
Bank Line of Credit |
$114,759 |
$295,865 |
||||||
Long-Term Debt – less current portion |
9,500,741 |
1,006,955 |
||||||
Deferred Income Taxes – net |
660,503 |
825,629 |
||||||
Total Liabilities |
$13,961,155 |
$4,878,506 |
||||||
Common Stock |
$29,055,488 |
|||||||
Retained Earnings / (Accumulated Deficit) |
4,392,494 |
891,504 |
||||||
Total Stockholders’ Equity |
$33,447,982 |
$29,946,992 |
||||||
Total Liabilities and Stockholders’ Equity |
Riordan Manufacturing, Inc. |
||||
|
||||
2011 |
2010 |
|||
Sales |
$66,608,660 |
$56,534,254 |
||
Direct Cost of Goods Sold |
51,592,470 |
43,970,250 |
||
Gross Margin |
$15,016,190 |
$12,564,004 |
||
Operating Expenses |
||||
Sales, Marketing & Other |
$1,328,615 |
$1,265,348 |
||
Depreciation |
1,378,616 |
1,152,125 |
||
Quality Assurance |
1,151,176 |
1,112,247 |
||
Research & Development |
1,039,637 |
962,627 |
||
General & Administrative |
4,954,751 |
4,674,293 |
||
Machining & Systems |
143,808 |
125,050 |
||
Total Operating Expenses |
$9,996,603 |
$9,291,690 |
||
Profit Before Interest & Taxes |
$5,019,587 |
$3,272,314 |
||
Non-Operating Expenses |
||||
Interest Expense |
$604,616 |
$121,533 |
||
Taxes |
1,104,309 |
719,909 |
||
Total Non-Operating Expenses |
$1,708,925 |
$841,442 |
||
Net Profit After Taxes |
$3,310,662 |
$2,430,872 |