Based on the above data, please comment on this project; comment on the indicators. comment...

70.2K

Verified Solution

Question

Finance

Based on the above data, please comment on this project; comment on the indicators. comment as much as possible. Thanks image
image
Tahoma 11 ini General AA Wrap Text A. Merge & Center NI do Cut Copy Format Painter Clipboard asto BIU. $ - % 4.000 100.0 Conditional Format as c Formatting Table Styl Styles Font To Alignment Number 22 X fr B D E 0 1 CASH FLOW 2 3 4 Year 5 Revenue Variable cost Gross profit Fixed cost 9 Depreciation 10 EBIT 11 Tax (20%) 12 Net income 13 OCF 14 NWC 15 NCS 16 Buy machinery Cost of industrial 18 Other cost 19 CFFA 20 21 NPV IRR 23 Financial Indicator 1 9,000,000,000 750,000,000 3,650,000,000 900,000,000 165,000,000 7,350,000,000 1470000000 5,880,000,000 6,045,000,000 2 12,600,000,000 765,000,000 7,085,000,000 900,000,000 165,000,000 10,935,000,000 2187000000 8,748,000,000 8,913,000,000 3 16,000,000,000 780,300,000 8,469,700,000 900,000,000 165,000,000 14,319,700,000 2863940000 11,455,760,000 11,620,760,000 -240,584,000 280,000,000 700,000,000 900,000,000 17 150,000,000 6,195,000,000 155,000,000 9,068,000,000 160,000,000 11,780,760,000 -1,840,584,000 574,893,593.81 83,33% WACC Break-even Analysis Revenue Forecast Cash flow Estimated pro... Font Alignment Number . 8 X & fx =SUM(D13:D14:D16) B REVENUE FORECAST Currency unit: VND 2021 Content Revenue Coconut coffee 2022 2023 600,000 products x 15,000/product 700,000 products 18,000/product 300,000 products 20.000 brodact Total revenue 9,000,000,000 12,600,000,000 16,000,000,000 Cost of goods sold Production line Production materials Labor cost Production expense 900,000,000 3,000,000,000 750,000,000 700,000,000 4,000,000,000 265,000,000 750,000,000 6,000,000,000 100, 200,000 750,000,000 Total cost of goods sold Gross profit Operating costs Operating profit Interest expenses Profit before tax Tax (20%) Profit after tax Pay dividends to shareholders Retained earnings 5.250,000,000 3,650,000,000 500,000,000 200,000,000 500,000,000 6,000,000,000 1.360,000,000 5.40,000,000 90.000.000 4.460,000,000 55100.000 700.000,00 550,000,000 350,000,000 150,000,000 19,200,000,000 2.040,000,000 8.160,000,000 1.100,000,000 7,060,000,000 7,5%29.000 09.09,000 550,000,000 199.000.000 400,000,000 11.560,000,000 7,212,000,000 10,043,000,000 200.000,00 8.000.000 EXPECTED RATIO OF EXPENSES ON REVENUE Determine the share of the costs cost of goods sold, operating expenses and interest expenses...) with the forecasted were Cost of good sold 6.100,000,000 9.000.000.000 = 67.7% Operating costs Heve 100,000,000 -5.5% 0.000.000.000 Financial indicator Break-even Analysis WACC Revenue Forecast Estimated pro Cash flow

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