Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ncome Statement ($000) AC Camera Revenues UAV Drone Revenues Total Revenues North America Europe Asia Africa Pacific Latin America 146.223 122.165 128.473 91.240 217,424
ncome Statement ($000) AC Camera Revenues UAV Drone Revenues Total Revenues North America Europe Asia Africa Pacific Latin America 146.223 122.165 128.473 91.240 217,424 212,398 170,231 104,300 363,647 334.563 298,704 195,540 Cost of Goods Sold Delivery Costs Marketing Costs Administrative Expenses Operating Profit (Loss) Profitability and Payout Year 13 Year 14 Other Income (Expense) Earnings Per Share Dividends Per Share $14.65 $0.00 $19.66 Pre-Tax Profit (Loss) $0.00 115,890 157,654 144,863 96,640 3,834 19,019 22,784 15.247 35,500 27,000 23,880 16,100 2,386 2,666 2,893 2,048 206,037 128,224 104,284 65,505 Company Total 488.101 704,353 1,192,454 515,047 60,884 102,480 9,993 504,050 Interest Income (Expense) 6,344 0 510,394 Income Taxes Net Profit (Loss) 153,118 357.276 Notes to Income Statement 1 Revenues listed here have been ad justed for promotional discounts and exchange rates. See the Market Seg- ment Performance reports for details on promotional discount and ex- change rate adjustments to revenues. 2 Other Income (Expense) will include charitable contributions, instructor- imposed fines (appearing as nega- tive), and instructor-award refunds (appearing as positive). 3 The income tax rate is 30%. If a net loss was recorded in Year 13, the loss is carried forward and may offset some or all taxable Year 14 profit and reduce the company's tax liability in Year 14. Shareholder Equity Common Stock (see Note 9) Beginnin virarige $000s g in Year 14 Repayment of Overdraft Loan 0 Balance 9,235 Additional Capital (see Note 10) -515,407 -150 -119,679 9,085 -635,088 Bank Loan Principal (see Note 4) 1-Year Loan 0 5-Year Loan 0 10-Year Loan 10,000 Retained Earnings 1,162,952 +357,276 1,520,228 Interest Payments -Year 14 Overdraft Loan 0 Total Shareholder Equity 656,780 +237,445 894,225 Bank Loans (1-year, 5-year, 10-year) 850 Return on Average Equity (see Note 11) 46.1% Stock Repurchases (300 shares repurchased @ $399.43) 119,829 153,118 0 0 0 Notes to Balance Sheet (all dollar and share figures in thousands) Note 1: Accounts receivable equals 25% of the camera revenues and 3rd-party drone revenues generated in Year 14 (to be collected in Year 15). Note 2: A 10% reserve of camera and drone components is kept at all times. Note 3: For more details, see the Assembly and Facility Operations report. Note 4: Accounts payable equals 25% of the cost of camera and drone components used in Year 14 (to be paid in Year 15). Note 5: Loans for overdrafts carry an interest rate 2% above the 1-year loan rate. Note 6: The company's 1-year bank loan interest rate in Year 14 was 4.0%. Note 7: Principal amount of 5-year and 10-year bank loans due to be paid in Year 15. Note 8: Long-term bank loans outstanding: Interest Payable Out- Loan Initial Original No. Year Principal Interest Rate standing Annual Principal Year 15 Term Principal Payment Y1 60,000 7.5 % 10-Yr 0 0 Y4 20,000 8.5% 10-Yr 0 0 Y4 80,000 8.5% 10-Yr 0 0 Y14 10,000 4.5 % 5-Yr 10,000 2,000 9 10 11 12345678TL 450000 Income Tax Payments Dividend Payments to Shareholders Charitable Contributions Cash Fines (assessed by instructor) Total Cash Outlays Net Cash Balance ($000s at the end of Year 14) Notes to Cash Flow Statement 975,099 668,071 Note 1: Receipts from sales equals all direct-sale drone revenues plus 75% of camera and 3rd-party drone revenues generated in Year 14. Note 2: Payments to component suppliers equals 75% of the cost of components used in Year 14 and 25% of the cost of components used in Year 13. Note 3: Production and assembly expenses include all Year 14 production-related ex- penses except for depreciation (which is a non-cash accounting charge). Note 4: Overdraft and 1-year loans received in Year 13 were repaid in full in Year 14. Interest on overdraft and 1-year loans received in Y13 was also paid in Y14. Credit Rating Measures Selected Financial Statistics Debt/Equity Percentage (Debt: Equity) 10:90 Interest Coverage Ratio (oper. prof. + int. exp.) 1,000.00 Current Ratio (current assets + current liabilities) Credit Rating (at the end of Year 14) 8.86 A+ 42.3% 30.0% 0.0% $9,734,03 2 Note 9: There are 18,170 shares of stock outstanding at a par value of $0.50 per share. Note 10: Total $ amount above par value that shareholders paid to purchase stock. Note 11: The formula for Return on Average Equity is: After-Tax Profit (Beginning Equity + Ending Equity) 2 Operating Profit Margin (operating profit net sales revenues) Net Profit Margin (net profit net sales revenues) Dividend Payout (dividend per share earnings per share) Market Capitalization ($535.72 stock price x 18,170 shares) Balance Sheet Cash Flow Statement Assets Cash on Hand $000s Cash Available in Year 14 $000s 668,071 Beginning Cash Balance (carried over from Year 13) 479,609 Accounts Receivable (see Note 1) 154,539 Cash Component Inventories (see Note 2) 34,449 Inflows Receipts from Sales (see Note 1) Bank Loan 1,146,367 1-Year 0 Total Current Assets 857,059 5-Year 10,000 Gross Investment in Plant and Equipment 309,000 10-Year 0 Less Accumulated Depreciation 167,100 Stock Issue (0 shares isued @$399.43) 0 Total Fixed Asset Investment (see Note 3) 141,900 Loan to Cover Overdraft 0 Total Assets 998,959 Interest on Year 13 Cash Balance Cash Refund (awarded by instructor) 7,194 0 Liabilities $000s Total Cash Available (from all sources) 1,643,170 Accounts Payable (see Note 4) 94,734 Cash Outlays in Year 14 $000s Overdraft Loan Payable (see Note 5) 0 1-Year Bank Loan Payable (see Note 6) 0 Current Portion of Long-Term Loans (see Note 7) 2,000 Total Current Liabilities 96,734 Capital Outlays Payments to Component Suppliers (see Note 2) Production and Assembly Expenses (see Note 3) Delivery, Marketing, and Administrative Expenses New Workstations 340,832 155,113 173,357 1,500 Long-Term Bank Loans (see Note 8) 8,000 Robotics Upgrades 0 Total Liabilities 104,734 Facilities Expansion 18,000 Facilities Improvements (CSRC) 2,500 Shareholder Equity Beginnin Change $000s g in Year 14 Repayment of Overdraft Loan 0 23 Balance Common Stock (see Note 9) 9.235 Additional Capital (see Note 10) -515,407 -150 -119,679 1,162,952 +357,276 656,780 +237,445 9,085 Bank Loan Principal 1-Year Loan 5-Year Loan 0 -635,088 1,520,228 894,225 (see Note 4) 10-Year Loan 10,000 46.1% Retained Earnings Total Shareholder Equity Return on Average Equity (see Note 11) Notes to Balance Sheet (all dollar and share figures in thousands) Note 1: Accounts receivable equals 25% of the camera revenues and 3rd-party drone revenues generated in Year 14 (to be collected in Year 15). Note 2: A 10% reserve of camera and drone components is kept at all times. Note 3: For more details, see the Assembly and Facility Operations report. Note 4: Accounts payable equals 25% of the cost of camera and drone components used in Year 14 (to be paid in Year 15). Note 5: Loans for overdrafts carry an interest rate 2% above the 1-year loan rate. Note 6: The company's 1-year bank loan interest rate in Year 14 was 4.0%. Note 7: Principal amount of 5-year and 10-year bank loans due to be paid in Year 15. Note 8: Long-term bank loans outstanding: Loan Initial No. Year Original Principal Interest Rate Term Out- Annual standing Principal Principal Payment Year 15 Interest Payable Cash Fines (assessed by instructor) Total Cash Outlays Net Cash Balance ($000s at the end of Year 14) Notes to Cash Flow Statement 975,099 668,071 Note 1: Receipts from sales equals all direct-sale drone revenues plus 75% of camera and 3rd-party drone revenues generated in Year 14. Note 2: Payments to component suppliers equals 75% of the cost of components used in Year 14 and 25% of the cost of components used in Year 13. Note 3: Production and assembly expenses include all Year 14 production-related ex- penses except for depreciation (which is a non-cash accounting charge). Overdraft and 1-year loans received in Year 13 were repaid in full in Year 14. Interest Payments Year 14 Overdraft Loan 0 Bank Loans (1-year, 5-year, 10-year) 850 Stock Repurchases (300 shares repurchased @ $399.43) Income Tax Payments 119,829 153,118 Dividend Payments to Shareholders Charitable Contributions 0 0 0
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started