Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Comment on the Financials Projections. Do you see the forecasted sales units and revenue reasonable? Why/Why Not? Is it connected to the Market Analysis? Can

image text in transcribed

image text in transcribed

Comment on the Financials Projections. Do you see the forecasted sales units and revenue reasonable? Why/Why Not? Is it connected to the Market Analysis? Can you provide a different forecast for sales units and revenue? If so provide a table for these two factors (forecasted sales units and revenue) and explain your rational.

Market Analysis: Customer Analysis Geographic: Psychographic: Urban Governorates VALS Personality Traits Cairo 100% Innovators Experiencers Giza 60.3% Alexandria 98% 19,817,143 Red Sea 96.7% Demographic: Age |50,000+ EGP Monthly household income 15 - 39 Year 3 04 Y2 Q1 Q2 Q3 04 Y3 18.45 22.7 8.405 25.215 58.835 75.645 168.1 56.75 21.01 Year 1 Year 2 Q1 Q2 03 04 Y1 Q1 Q2 93 Sales unit (in thousands) 0.5 1.5 3.5 4.5 10 2.05 6.15 14.35 Sales revenue (million LE) 1.25 3.75 8.75 1125 25 5.125 15.375 35.875 |- COGS 52500 127500 277500 352500 765000 168750 476250 1091250 Gross Profit 1,197,500 3,622,500 8,473,500 10,897,500 242,335,000 4,956,250 14,898,750 34,783,750 1- SG&A 155,000 145,000 145,000 145,000 590,000 160,000 165,000 165,000 EBIT 1,042,500 3,477,500 8,328,500 10,752,500 241,745,000 4,796,250 14,733,750 34,618,750 Cumulative 1,042,500 4,520,000 12,848,500 23,601,000 265,346,000 270,142.250 284.876,000 319,494,750 Profit 46.125 1398750 34,783,750 170,000 1717500 645375 5,503,250 20,364,625 660,000 160,000 4,843,250 20,204.625 358.951.750 379.156,375 63.0375 147,0875 189.1125 420.25 1906125 4427625 5688375 12622500 61,131,375 114,087,500 183,424,125 407,627,500 160,000 145,000 150,000 615,000 60,971,375 113,942,500 183,274,125 407,012,500 440,127,750 554,070,250 737,344.375 1.144,356,875 34,613,750 354.108.500 Market Analysis: Customer Analysis Geographic: Psychographic: Urban Governorates VALS Personality Traits Cairo 100% Innovators Experiencers Giza 60.3% Alexandria 98% 19,817,143 Red Sea 96.7% Demographic: Age |50,000+ EGP Monthly household income 15 - 39 Year 3 04 Y2 Q1 Q2 Q3 04 Y3 18.45 22.7 8.405 25.215 58.835 75.645 168.1 56.75 21.01 Year 1 Year 2 Q1 Q2 03 04 Y1 Q1 Q2 93 Sales unit (in thousands) 0.5 1.5 3.5 4.5 10 2.05 6.15 14.35 Sales revenue (million LE) 1.25 3.75 8.75 1125 25 5.125 15.375 35.875 |- COGS 52500 127500 277500 352500 765000 168750 476250 1091250 Gross Profit 1,197,500 3,622,500 8,473,500 10,897,500 242,335,000 4,956,250 14,898,750 34,783,750 1- SG&A 155,000 145,000 145,000 145,000 590,000 160,000 165,000 165,000 EBIT 1,042,500 3,477,500 8,328,500 10,752,500 241,745,000 4,796,250 14,733,750 34,618,750 Cumulative 1,042,500 4,520,000 12,848,500 23,601,000 265,346,000 270,142.250 284.876,000 319,494,750 Profit 46.125 1398750 34,783,750 170,000 1717500 645375 5,503,250 20,364,625 660,000 160,000 4,843,250 20,204.625 358.951.750 379.156,375 63.0375 147,0875 189.1125 420.25 1906125 4427625 5688375 12622500 61,131,375 114,087,500 183,424,125 407,627,500 160,000 145,000 150,000 615,000 60,971,375 113,942,500 183,274,125 407,012,500 440,127,750 554,070,250 737,344.375 1.144,356,875 34,613,750 354.108.500

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance In Theory And Practice

Authors: Richard Abel Musgrave, Peggy B. Muscrave

5th Edition

0070441278, 978-0070441279

More Books

Students also viewed these Finance questions

Question

What is the critical value of F on your Excel printout?

Answered: 1 week ago