Here are the abbreviated financial statements for Planner's Peanuts: INCOME STATEMENT, 2022 Sales Cost Net income $ 7,000 5,500 $ 1,500 2021 BALANCE SHEET, YEAR-END 2022 Assets $ 2,500 $ 3,000 Total $2,500 $ 3,000 Debt Equity Total 2021 $ 853 1,647 $ 2,500 2022 $ 1,000 2,000 $ 3,000 Assets are proportional to sales. If the dividend payout ratio is fixed at 50%, calculate the required total external financing for growth rates in 2023 of (a) 40%, (b) 45%, and (c) 50%. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. External Financing Need (a) 40% (b) 45% (၁) 50%

Here are the abbreviated financial statements for Planner's Peanuts: INCOME STATEMENT, 2022 Sales Cost Net income $ 7,000 5,500 $ 1,500 2021 BALANCE SHEET, YEAR-END 2022 Assets $ 2,500 $ 3,000 Total $2,500 $ 3,000 Debt Equity Total 2021 $ 853 1,647 $ 2,500 2022 $ 1,000 2,000 $ 3,000 Assets are proportional to sales. If the dividend payout ratio is fixed at 50%, calculate the required total external financing for growth rates in 2023 of (a) 40%, (b) 45%, and (c) 50%. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. External Financing Need (a) 40% (b) 45% (၁) 50%

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

8th Edition

ISBN:9781285065137

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter16: Financial Planning And Forecasting

Section: Chapter Questions

Problem 15SP: Comprehensive/Spreadsheet Problem 16-15 FORECASTING FINANCIAL STATEMENTS Use a spreadsheet model to...

See similar textbooks

Similar questions

In Set’ Dec. 31, 2020 statement of financial position, how much should be the accounts payable? *see attached a. P 1,410,000b. P 1,485,000c. P 1,462,500d. P 1,425,000
What is the amount of prepaid/accrued benefit cost that should be shown on the December 31, 2019 statement of financial position? 560,000 700,000 840,000 2,520,000 answer not given
Items Balance, Jan. 1, 2025 (a) Service Cost (b) Interest Cost (c) Actual Return (d) Contributions (e) Benefits Journal Entry for 2025 Balance, Dec. 31, 2025 The service cost for 2025 is O $115000. O $6000. O $37000. O $38000. Annual Pension Expense ?? dr 15000 dr General Journal Entries 16000 cr $37000 Pharoah Corporation Pension Worksheet Cash $37000 cr ?? Show Transcribed Text Pension Asset/ Liability ?? Memo Record Projected Benefit Obligation $115000 cr $115000 dr ?? Plan Assets ??
B. An entity provided the following information during the current year:January 1 December 31Fair value of plan assets 6,000,000 9,000,000Projected benefit obligation 4,500,000 5,000,000Prepaid/accrued benefit cost – surplus 1,500,000 4,000,000Asset ceiling 1,000,000 2,500,000Effect of asset ceiling 500,000 1,500,000During the year, the entity recognized current service cost P2,000,000, actual return on plan assets P400,000,and contribution to the plan P4,550,000 and benefits paid P1,950,000. The discount rate is 10% REQUIRED:9. Compute the amount of prepaid benefit cost that should be reported on December 31
B. An entity provided the following information during the current year:January 1 December 31Fair value of plan assets 6,000,000 9,000,000Projected benefit obligation 4,500,000 5,000,000Prepaid/accrued benefit cost – surplus 1,500,000 4,000,000Asset ceiling 1,000,000 2,500,000Effect of asset ceiling 500,000 1,500,000During the year, the entity recognized current service cost P2,000,000, actual return on plan assets P400,000,and contribution to the plan P4,550,000 and benefits paid P1,950,000. The discount rate is 10% REQUIRED: 6. Compute the employee benefit expense for the current year
B. An entity provided the following information during the current year:January 1 December 31Fair value of plan assets 6,000,000 9,000,000Projected benefit obligation 4,500,000 5,000,000Prepaid/accrued benefit cost – surplus 1,500,000 4,000,000Asset ceiling 1,000,000 2,500,000Effect of asset ceiling 500,000 1,500,000During the year, the entity recognized current service cost P2,000,000, actual return on plan assets P400,000,and contribution to the plan P4,550,000 and benefits paid P1,950,000. The discount rate is 10% REQUIRED:8. Compute the defined benefit cost
B. An entity provided the following information during the current year:January 1 December 31Fair value of plan assets 6,000,000 9,000,000Projected benefit obligation 4,500,000 5,000,000Prepaid/accrued benefit cost – surplus 1,500,000 4,000,000Asset ceiling 1,000,000 2,500,000Effect of asset ceiling 500,000 1,500,000During the year, the entity recognized current service cost P2,000,000, actual return on plan assets P400,000,and contribution to the plan P4,550,000 and benefits paid P1,950,000. The discount rate is 10% REQUIRED:7. Compute the net remeasurement loss for the current year
Prepare a vertical analysis scheduleHere is the operating data for Yalis Cleaning, Inc.:2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150PurposeThe purpose of this problem is to demonstrate an understanding of preparing a vertical analysis schedule.InstructionsAfter analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenueas the base amount. Round percentages to two decimal places.GuidanceFor formatting guidance, see the vertical analysis examples that are provided in Chapter 13 of the textbook.
Use the below information to answer the following questions: 20202021Sales$11,573$12,936Depreciation 1661 1736Cost of goods sold 3979 4707Other Expenses 846 924Interest Expense 776 926Cash 6067 6466Accounts Receivables 8034 9427Short-term Notes Payable 1171 1147Long-term debt 20,320 24,696Net fixed assets 50,888 54,273Accounts Payable 4384 4644Tax rate 26% 34%Inventory 14,283 15,288Payout ratio 33% 30% A. Create the Balance Sheets for 2020 & 2021.
Use the below information to answer the following questions: 20202021Sales$11,573$12,936Depreciation 1661 1736Cost of goods sold 3979 4707Other Expenses 846 924Interest Expense 776 926Cash 6067 6466Accounts Receivables 8034 9427Short-term Notes Payable 1171 1147Long-term debt 20,320 24,696Net fixed assets 50,888 54,273Accounts Payable 4384 4644Tax rate 26% 34%Inventory 14,283 15,288Payout ratio 33% 30% A. Create the Income Statements for 2020 and 2021 (including dividends paid and retained earnings).
Determine Total Current Liabilities as of December 31, 2023: Select one: a. $27,300 b. $39,900 c. $144,900 d. $132,300 e. $247,350
Accounts Payable as of December 31, 2020 should amount to: *A. 531,000B. 600,000C. 627,000D. 1,827,000