Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please answer in excel sheet or word . no overvie

Please answer in excel sheet or word . no Overview 3. External Funds Needed...

50.1K

Verified Solution

Question

Accounting

image

Please answer in excel sheet or word .

no Overview 3. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 perce nt for next year. The current financial statements are shown here: Income Statement $25,380.000 Sales Costs Taxable income Taxes Net income $3,745,000 1,498.000 2,247,000 $ 786,450 Addition to retained earnings 1,460,550 Balance Sheet Assets Liabilities and Owners' Equit Current assets 7.200,000 Short-term debt Fixed assets 17600,000 $ 5.200,000 6,000,000 Long-term debt 3,200,000 10.400.000 $13,600,000 $24,800,000 Common stock Accumulated retained earnings Total equity Total assets $24,800,000 Total liabilities and equity a. Using the equation from the chapter, calculate the external funds needed for next year Construct the fim's pro forma balance sheet for next year and confirm the extema funds needed that you calculated in part (a). external c. Calculate the sustainable growth rate for the company d. Can the company eliminate the need for external funds by changing its divth policy? What other options are available to the company to meet its grow objectives

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students