Group Problem Set 1 - Group_K

docx

School

Campbellsville University *

*We aren’t endorsed by this school

Course

60298 H1

Subject

Finance

Date

Jan 9, 2024

Type

docx

Pages

9

Uploaded by gundaswaroop14

Report
Managerial Finance Professor - Dr. Sunny Onyiri Group Problem Set 1 Group K Date: 08/04/2021 By Venkata Krishna Anumula Guneet Banwait Yugandhar Chippala Vijay Gummadavelli Nikitaben Patel
Part 1: Financial Statements A. Below statement would help us to understand about the retained earnings for 2017 and the company has paid $11,000 in the year 2017 B. C. Prepare the balance sheet for 2016 and 2017 Balance sheet for 2016 and 2017 2016 2017 Assets Cash 9,000 7,282 Short-term investments 48,600 20,000 Accounts Receivable 351,200 632,160 Inventory 715,200 1,287,360 This study resource was
Total Current 9,000 + 48,600 + 351,200 + 715,200 = 7,282 + 20,000 + 632,160 + 1,287,360 Assets 1,124,000 = 1,946,802 Gross Fixed Assets 491,000 1,202,950 Accumulated Depreciation (146,200) (263,160) 1,202,950 – 263,160 491,000 – 146,200 = = Net Assets 344,800 939,790 1,124,000 + 344,800 1,946,802 + 939,790 = = Total Assets 1,468,800 2,886,592 Liabilities and Shareholder Equity Liabilities Accounts payable 145,600 324,000 Notes Payable 200,000 720,000 Accruals 136,000 284,960 145,600 + 200,000 + 324,000 + 720,000 + Total Current 136,000 = 284,960 = Liabilities 481,600 1,328,960 Long-term debt 323,432 1,000,000 1,328,960 + 481,600 + 323,432 = 1,000,000 = Total Liabilities 805,032 2,328,960 1,328,960 + Shareholder Equity Common Stock 460,000 460,000 Retained Earnings 203,768 97,632 Total Shareholder 460,000 + 203,768 = 460,000 + 97,632 =
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Equity 663,768 557,632 Total Liabilities and Shareholder 805,032 + 663,768 = 2,328,960 + 557,632 = Equity 1,468,800 2,886,592 D. Prepare Common-Size financial statements of income statement and balance sheet Common-size Income Statement for 2016 & 2017 2016 2017 Sales 100% 100% Cost of goods sold 83% 85% Gross Profit 17% 15% Other Expenses 10% 12% Depreciation 1% 0% Total Operating Expenses 10% 13% Interest expense 2% 3% Expenses before Taxes (EBT) 4% -3% Income tax expense 2% -1% Net income 3% -2% Common-Size Balance Sheet for 2016 & 2017 2016 2017 Cash 1% 0% Short-term Investments 3% 1% Trade receivables 24% 22% Inventory 49% 45% Current Assets 77% 67% Gross Fixed Assets 33% 42% Accumulated Depreciation -10% -9%
Non-current Assets 23% 33% Total Assets 100% 100% Accounts Payable 10% 11% Notes Payable 14% 25% Accruals 9% 10% Current Liabilities 33% 46% Long-term debt 22% 35% Non-current Liabilities 22% 35% Total Liabilities 55% 81% Common Stock 31% 16% Retained Earnings 14% 3% Total Shareholder Equity 45% 19% Total Equity & Liabilities 100% 100% E. Prepare Statement of Cash Flows. Statement of Cash Flows for 2016 and 2017 Current Period Prior Period Increase (Decrease) 2017 2016 2016-2017 BEGINNING CASH ON HAND 7,282.00 9,000.00 (1,718.00) ADD: CASH RECEIPTS Cash Sales 5,834,400.00 3,432,000.00 2,402,400.00 Misc. Cash Receipts - TOTAL CASH RECEIPTS 5,834,400.00 3,432,000.00 2,402,400.00 LESS: CASH PAYMENTS COST OF GOODS SOLD: Direct Product/Service Costs 4,980,000.00 2,864,000.00 2,116,000.00 Supplies - Other Costs - Sub-Total Cost of Goods Sold 4,980,000.00 2,864,000.00 2,116,000.00 OPERATING EXPENSES: Other Expenses 720,000.00 340,000.00 380,000.00 Depreciation 116,900.00 18,900.00 98,000.00 Sub-Total Operating Expenses 836,900.00 358,900.00 478,000.00
OTHER EXPENSE PAYMENTS Interest Expense 176,000.00 62,500.00 113,500.00 Income Tax Expense (63,424.00) 58,640.00 (122,064.00) Cash Disbursements to Owners - - - Sub-Total Other Expense Payments 112,576.00 121,140.00 (8,564.00) TOTAL CASH PAYMENTS 5,929,476.00 3,344,040.00 2,585,436.00 NET CASH CHANGE - Inflow (Outflow) (95,136.00) 87,960.00 (183,036.00) CASH POSITION (end of month) (87,794.00) 96,960.00 (184,754.00) Part 2: Financial Statement Analysis A.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
B. Comments on the ratios by comparing 2016 to 2017 ratios. For quick ration if the value is less than 1 then the company might not be able to pay fylly its current liability In 2017 the current ratio shows that the company is not able to and 2017 the asset turnover ratio has been declining C. Assume Adams Stores, Inc. is a retail company similar to WalMart, Myers, or Target. Compare 2017 ratios to the industry average. Please note that Adams Stores, Inc. is not a real company. To find comparable industry ratios, you need to search for industry ratios for retail. See information on Moodle for instructions on how to find industry ratios. Based on the industry average, how is Adams Stores, Inc. doing financially? In 2016 current ratio better but it is infact lower than the industry standard In both years quick ratio is not doing good Debt ratios are much higher than industry standard. Part 3: Break-even, Financial and Operating Leverages
Break Even Point: b. What is the degree of financial leverage? Explain what your number mean. As a manager, how would you use the numbers in financial planning? Degree of Financial leverage = EBIT/EBT = $400,000/$280,000 =1.43 The advantages of this financial leverage arise based on funds are considered towards financial leverage. c. What is the degree of operating leverage? Explain what your number mean. As a manager, how would you use the numbers in financial planning? Degree of operating Leverage = Contribution/EBIT =1,000,000/400,000 = 2.5 This would impact of change in sales and managed level of operating profits and number can be used for the purpose of handling risky situations in the financial planning.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help