Attached is my Milestone 01 and 02 Management Briefs, along with my financial notes. Additionally, I have attached feedback from Milesto
Attached is my Milestone 01 and 02 Management Briefs, along with my financial notes. Additionally, I have attached feedback from Milestones 01 and 02 so these two milestones can be informed up on the final project rubric is attached as well.
Looking for help to bring these milestones up to 100% for the Final Project which is 350 pts.
ACC 308 Final Project: Milestone II Part II: Financial Notes
Tim Weaver
Southern New Hampshire University
Financial Notes
References
Bragg, S. (2019). Straight line depreciation. Retrieved April 3, 2022, from https://www.accountingtools.com/articles/2017/5/15/straight-line-depreciation
Supply Management: An Overview. (2019). Retrieved April 3 2022, from https://www.investopedia.com/terms/s/supplymanagement.asp
,
5-1 Final Project Milestone Two: Management Analysis Brief
Tim Weaver
Intermediate Accounting II
April 8, 2022
Professor Snyder
Running head: Milestone II Management Brief 1
3
MANAGEMENT BREIF
It is always good to see a business experience growth each year, and even more exiting when the business makes a decision to expand due to the continued success of the initial location. Therefore, in this analysis brief we will be discussing the both the pro forma balance sheet and income statement, as well any implications that of current liabilities, revenue recognition, and inventory costing. Additionally, it will be discussed if there were any potential issues that was found in preparing the financial statements that could impact the expansion of business by the addition of a second location. We are going to primarily focus on the financial statements that were generated from Peyton Approved during the 2015 – 2018 time period.
The first item to be discussed is the creation of the pro forma statements themselves. Using these financial statements, it can be analyzed to make the final decision about expanding the current business to a second location, when a business is considering making this expansion, there are several other expenses that need to be taken into consideration in addition to the current expenses for the current location. Additional expenses such as additional inventory, cost of acquiring new employees, purchase and maintenance of new equipment, and the cost of leasing the additional space for the second location. The use of pro forma balance sheet statements is not regulated or made by by the GAAP (Generally Accepted Accounting Principles), as they are only a tool to help predict the potential possibility of what could happen based on the current financial data, therefore, it is also critical that the information given about the pro forma balance sheet is a not a financial fact, only projections when showing this to potential investors of the organization. The pro forma income statement shows a positive project for the additional location, however that income is still projected to be 42.2% lower than the net income that it is receiving at the location it currently occupies. However, in the bigger picture, it is my recommendation to continue with the expansion, as they still be operating with making a profit at the additional location, and the overall bottom line of the organization would still be increased by the expansion.
However, there are also some issues that do need to be discussed which include inventory costing, contingent liabilities, and revenue recognition. The first issue that we will address is the use of the LIFO (last in, first out) system that is currently in place. While, this inventory system considers the most recently made products to be the first products that are sold, it does create a lot of waste. Changing the system over to a FIFO (first in, first out) would create less waste and also generate higher revenue due to the decreased waste and decreased inventory cost (Kenton, 2018). Additionally, it does need to be kept in mind that the when you change the system of how inventory is managed, then the amount of inventory dollars is going to change on the statements as well.
Kenton (2018) defines contingent liability as “potential liability that may occur depending on the outcome of an uncertain event.” One way to think about this would be consider what would happen if the organization was in a lawsuit or produced products that the organization had decided would come with a warranty, which from a financial statement point of view should be recorded on a balance sheet. An example would be the organization got hit with legal fees in the amount of one million dollars, which the accountant would then record as a debit of one million dollars and would place a one-million-dollar credit in accrued expense. These are contingent because there is no way to predict if the organization is going to have them, however, it is a good idea to have an estimated amount and make sure that amount is included on the financial statements of the organization.
The third issue that needs to be addressed is revenue recognition. CFI Education, Inc (2019) “revenue recognition is an accounting principal that outlines the specific conditions under which revenue is recognized.” Additionally, it is stated CFI Education, Inc (2019) “there are five principals that are used for recognizing revenue; identification of client contact, identification of obligations in client contract, determination of the price of transaction, allocate the transaction price according to the performance obligations in the client contract, and recognize the revenue when the performance obligations are met. These five principals are established by the FASB (Financial Accounting Standard Board) which also sets the standards for the United States General Accepted Accounting Principles.” Being able to predict revenue recognition is not a task that can be done easily, therefore the best way to handle these projections is to use the prior’s year’s financial statements.
Regarding the pro forma statements, when those statements are being prepared to be presented to stockholders, management, and investors, it is best to make sure that they are being prepared the same way each time in order to ensure that the information being presented in those reports is accurate. Due to the fact, that different organizations use different ways to have these documents prepared, it could be helpful if a brief description of how the financial document was prepared was made available to the person who is reading the document and analyzing the data that is contained in the report. Additionally, the other expenses like depreciation, interest and taxes, one-time expenses, amortization, losses from affiliates, and restructuring cost are all items that are typically not seem on these pro forma statements. Simply due to these items not being considered to being a true expense of the organization, that is why that are not being listed as an expense of the organization, nor can they be considered to show earning potential of the organization.
Based on the given information and looking at both the pro forma income statement and balance sheet, expanding to the second location would be a good idea for Peyton Approved. Although, based on the information, there will be a decrease in the net income for the first year of the organization being in the new location, it will ultimately bring in additionally revenue and increase the bottom-line profit of the organization. Therefore, based on the bigger picture and looking at the financial health of the organization overall, yes this would be a good move for the organization, and would recommend the expansion.
References
CFI Education Inc. (2019). Revenue Recognition – Principles, Criteria for Recognizing Revenues. Retrieved April 1, 2022, from https://corporatefinanceinstitute.com/resources/knowledge/accounting/revenue-recognition/
Kenton, W. (2018, December 13). Contingent Liability. Retrieved April 1, 2022, from https://www.investopedia.com/terms/c/contingentliability.asp
Kenton, W. (2018, December 13). Last In, First Out – LIFO. Retrieved April 1, 2022, from https://www.investopedia.com/terms/l/lifo.asp
,
ACC 308 Final Project: Milestone II Part II: Financial Notes
Tim Weaver
Southern New Hampshire University
Notes of Financial Statements
Note 01 – Supplies
The ability of being able to manage the supplies that are needed for the company to be able to continue growth and operate in the most efficient way is called Supply Management. This not only allows relates to the ability of the organization to be able to manage, obtain, and identify essential supplies for organizational operations, but is also allows the organization to be able to obtain the required information, physical good, and services they need (Supply Management: An Overview, 2019). The essential focus on supply management is maintaining control of cost of supplies, gathering of data to make sound business decisions, and resource allocation. Peyton Approved organization has a supplies total of $27,986.00. It is critically essential that the organization has clear understanding of raw materials, cost, and the products made in the end to ensure that there is no errors and risk has been ensured to be minimized in how the organization manages its supplies.
Note 02 – Inventory
The organization of Peyton Approved uses a Last In, First Out (LIFO) inventory management system. While this LIFO system would be good to use for somethings, it would not be recommended to be used on all of the organizations products. The organization currently has a merchandise inventory valued at $229.27. The organization, should ideally be continually looking for ways in which it would be possible to keep this amount at a minimum cost. This cost minimized would be associated with supplies, manufacturing of products, merchandise, and inventory. One of the methods that can be used to keep current and accurate inventory reports in order to be able to forecast supply demand and also avoid shortages. Instituting the use of inventory reports would be highly recommended as it will help ensure accurate inventory management at both locations of the organization and help ensure that neither location has a supply shortage.
Note 03 – Depreciation
The organization uses straight-line method in order to calculate the amount of depreciation. This method of calculation, as described by Bragg (2019) states that this method is calculated by equally distributing the depreciation through the life time of the given asset, the simplest method to use, and has the least likelihood of errors. While they use this method at the main location, it would be highly recommended that they continue to use particular method at the second location as well. Additionally, this would also allow the management team, investors, and shareholders in the organization to look at the equipment depreciation evenly at both locations, and would keep the comparisons on an equal playing field. When looking at both the Pro Forma Balance Sheets and Income Statements it can be seem that the depreciation is values at $2,143.00
Note 04 – Long Term Debt
The organization has one long-term debt, which is a loan that is scheduled to last 5 years, or 60 months with an interest rate of 7.5 APR. The loan was originated on June 1, 2016 and the principal amount of the loan $15,00, which is due on May 31, 2026, which only interest amount of $211.46 being due on an annual basis. Would recommend paying the loan off as quickly as possible, however if the loan had to be spread out, ear marking $3,000 each year, would allow for an even spread of the $15,0000 over a 5-year period. Total loan with the addition of interest for the full duration would be $16,057.30, would yearly would be $3,211.46.
References
Bragg, S. (2019). Straight line depreciation. Retrieved April 3, 2022, from https://www.accountingtools.com/articles/2017/5/15/straight-line-depreciation
Supply Management: An Overview. (2019). Retrieved April 3 2022, from https://www.investopedia.com/terms/s/supplymanagement.asp
,
HOME
Southern New Hampshire University | ||||||||
ACC 308 – Intermediate Accounting II | ||||||||
Note: This workbook contains instructions and financial information you will need to complete the Workbook portions of Milestones One and Two. For full instructions for the milestone and final project assignments, refer to the guidelines and rubric documents. You can use the links below to navigate from this HOME tab to additional instructions and the worksheets for each milestone. | ||||||||
MILESTONE ONE (Due in Module Three) | MILESTONE TWO (Due in Module Five) | FINAL PROJECT (Due in Module Seven) | ||||||
Milestone One Workbook Instructions | Milestone Two Workbook Instructions | Note: The final project consists of corrected work from Milestone One and Milestone Two. Incorporate the feedback you received from your instructor. | ||||||
1. Trial Balance | 1. Pro Forma Financial Statements | |||||||
Using the Peyton Approved financial data, create: | Using the given pro forma information, create: | |||||||
Adjusting Entries | Pro Forma Income Statement | |||||||
Adjusted Trial Balance | Pro Forma Balance Sheet | |||||||
2. Revised Financial Statements | 2. Notes to the Financial Statements | |||||||
Note: This part of the project is submitted as a separate Word document. Refer to the Milestone Two Guidelines and Rubric document for submission guidelines. | ||||||||
Using the trial balance and preliminary financial statements, prepare: | Your notes must contain the following: | |||||||
Revised Balance Sheet | A. Create appropriate notes as year-to-year documentation for managing depreciation, supplies, and inventory. | |||||||
Revised Income Statement | B. Create appropriate notes for long-term debt. | |||||||
Revised Retained Earnings Statement | ||||||||
Revised Statement of Cash Flows | ||||||||
3. Ratio Analysis | 3. Management Analysis Brief | |||||||
Note: Refer to the Final Project Scenario for Peyton's ratio formulas. | Note: This part of the project is submitted as a separate Word document. Refer to the Milestone Two Guidelines and Rubric document for submission guidelines. | |||||||
Using the financial statements from 2015, 2016, and revised 2017, calculate the following ratios: | Your management analysis brief should explain financial information to management. Provide evidence from your accounting workbook to support your ideas where applicable. | |||||||
Current Ratio (Working Capital) | A. Discuss the impact of the pro forma financial statements for predicting ability to meet future expansion goals. | |||||||
Quick Ratio | B. Describe the implications of inventory costing, contingent liabilities, and revenue recognition. | |||||||
A/R Turnover | C. Identify potential issues in interpretation of financial information, providing examples to support your ideas. | |||||||
Inventory Turnover | ||||||||
Gross Margin | ||||||||
Return on Sales | ||||||||
Return on Equity | ||||||||
Return on Assets | ||||||||
4. Management Analysis Brief | ||||||||
Note: This part of the project is submitted as a separate Word document. Refer to the Milestone One Guidelines and Rubric document for submission guidelines. | ||||||||
Your management analysis brief should explain financial information to management. Provide evidence from your accounting workbook to support your ideas where applicable. | ||||||||
A. Assess the company’s financial health based on ratio analyses presented in the accounting workbook. | ||||||||
B. Compare ratio analysis to trends in financial ratios over time for illustrating their impact, providing examples to support your claims. | ||||||||
C. Summarize the effects of different compounding periods and interest rates on future value of money. | ||||||||
D. Explain how alignment to relevant regulations and ethical reporting influenced your accounting practices and notes, providing examples to support your claims. | ||||||||
Milestone One Instructions
Return HOME | |
INSTRUCTIONS FOR MILESTONE ONE (Due in Module Three) | |
Note: Make sure to completely review the Milestone One Guidelines and Rubric document. | |
Use the data from this milestone and begin working on your final project, due in Module Seven. | |
ITEMS TO COMPLETE FOR MILESTONE ONE: | |
The tabs to complete are linked below and colored blue for convenience. | |
GENERAL | |
You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare the company’s financials for the year-end audit. Additionally, the company is interested in expanding its business within the next year. They would like your support in assessing their ability to meet their goals. | |
1. TRIAL BALANCE | |
Using the Peyton Approved financial data provided below: | |
A. Create the necessary adjusting journal entries. Use the REF column to reference the entry to each event. | |
B. Complete the adjusted trial balance. | |
Trial Balance 2017 | |
2. REVISED FINANCIAL STATEMENTS | |
Peyton Approved's preliminary financial statements are provided in the yellow tabs. | |
Balance Sheet 2017 | |
Income Statement 2017 | |
Retained Earnings 2017 | |
Cash Flow 2017 | |
Using the preliminary financial statements and the Trial Balance 2017, prepare the following statements: | |
Balance Sheet 2017 Revised | |
Income Statement 2017 Revised | |
Retained Earnings Statement 2017 Revised | |
Statement of Cash Flows 2017 Revised | |
Note: Refer to Module Three resources for a refresher on statement of cash flows. | |
Peyton Approved's previous years' financial statements are provided in the orange tabs. | |
Balance Sheet 2015 | |
Balance Sheet 2016 | |
Income Statement 2016 | |
3. RATIO ANALYSIS | |
Using the revised 2017 financial statements, 2016 financial statements, and 2015 financial statements, prepare a ratio analysis for Peyton Approved. | |
Note: Refer to the Final Project Scenario for Peyton's ratio formulas. | |
Ratio Analysis | |
PEYTON APPROVED FINANCIAL DATA | |
Preliminary financial statements have already been prepared (2017 statements in the Final Project Workbook). Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be recorded at 12/31/17 (fiscal year end). Use the following to complete year-to-year documentation and notes for managing depreciation, inventory, and long-term debt. | |
1. A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for $3,175—goods of $3,000 and freight of $175—all dated 12/29/17. Goods were shipped FOB supplier’s warehouse. | |
2. At 12/31/17, Peyton has $200 worth of merchandise on consignment at Bruno’s House of Bacon. | |
3. On 12/23/17, Peyton received a $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January. | |
4. On 12/03/2017, a mixer with cost of $2,000, accumulated depreciation $1,200, was destroyed by a forklift. As of 12/23/17, insurance company has agreed to pay $700 in January 2018, for accidental destruction. | |
4. MANAGEMENT ANALYSIS BRIEF | |
Note: This part of the project is submitted as a separate Word document. Refer to the Milestone One Guidelines and Rubric document for submission guidelines. | |
Your management analysis brief should explain financial information to management. Provide evidence from your accounting workbook to support your ideas where applicable. | |
A. Assess the company’s financial health based on ratio analyses presented in the accounting workbook. | |
B. Compare ratio analysis to trends in financial ratios over time for illustrating their impact, providing examples to support your claims. | |
C. Summarize the effects of different compounding periods and interest rates on future value of money. | |
D. Explain how alignment to relevant regulations and ethical reporting influenced your accounting practices and notes, providing examples to support your claims. | |
Trial Balance 2017
Milestone One Workbook Instructions | ||||||||||||||||
PEYTON APPROVED | ||||||||||||||||
TRIAL BALANCE | ||||||||||||||||
As of December 31, 2017 | ||||||||||||||||
Unadjusted trial balance | Adjusting entries | Adjusted trial balance | ||||||||||||||
Dr | Cr | ref | Dr | Cr | ref | Dr | Cr | |||||||||
Cash | 67,520.04 | 1,000.00 | 68,520.04 | |||||||||||||
Accounts Receivable | 68,519.91 | 68,519.91 | ||||||||||||||
Other Receivable – Insurance | 700.00 | 700.00 | ||||||||||||||
Baking Supplies | 15,506.70 | 3,175.00 | 18,681.70 | |||||||||||||
Merchandise Inventory | 1,238.07 | 200.00 | 1,038.07 | |||||||||||||
Consignment Inventory | 200.00 | 200.00 | ||||||||||||||
Prepaid Rent | 2,114.55 | 2,114.55 | ||||||||||||||
Prepaid Insurance | 2,114.55 | 2,114.55 | ||||||||||||||
Misc. Supplies | 170.49 | 170.49 | ||||||||||||||
Baking Equipment | 14,000.00 | 2,000.00 | 12,000.00 | |||||||||||||
Accumulated Depreciation | 1,606.44 | 1,200.00 | 406.44 | |||||||||||||
Customer Deposit | 1,000.00 | 1,000.00 | ||||||||||||||
Accounts Payable | 20,262.11 | 3,175.00 | 23,437.11 | |||||||||||||
Wages Payable | 3,383.28 | 3,383.28 | ||||||||||||||
Interest Payable | 211.46 | 211.46 | ||||||||||||||
Notes Payable | 5,000.00 | 5,000.00 | ||||||||||||||
Common Stock | 20,000.00 | 20,000.00 | ||||||||||||||
Beginning Retained earnings | 50,144.84 | 50,144.84 | ||||||||||||||
Dividends | 105,000.00 | 105,000.00 | ||||||||||||||
Bakery Sales | 327,322.55 | 327,322.55 | ||||||||||||||
Merchandise Sales | 1,205.64 | 1,205.64 | ||||||||||||||
Cost of Goods Sold – Baked | 105,834.29 | 105,834.29 | ||||||||||||||
Cost of Goods Sold – Merchandise | 859.77 | 859.77 | ||||||||||||||
Rent Expense | 24,549.19 | 24,549.19 | ||||||||||||||
Wages Expense | 10,670.72 | 10,670.72 | ||||||||||||||
Misc. Supplies Expense | 3,000.46 | 3,000.46 | ||||||||||||||
Business License Expense | 2,045.77 | 2,045.77 | ||||||||||||||
Misc. Expense | 1,363.84 | 1,363.84 | ||||||||||||||
Depreciation Expense | 677.86 | 677.86 | ||||||||||||||
Insurance Expense | 1,091.08 | 1,091.08 | ||||||||||||||
Advertising Expense | 1,549.74 | 1,549.74 | ||||||||||||||
Interest Expense | 818.31 | 818.31 | ||||||||||||||
Telephone Expense | 490.98 | 490.98 | ||||||||||||||
Gain/Loss on disposal of equipment | 100.00 | |||||||||||||||
429,136.32 | 429,136.32 | 6,375.00 | 6,375.00 | 432,011.32 | 432,111.32 | |||||||||||
<div
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.