Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Develop your Model is EXCEL. your report should be in WORD. For the e-Travel guide company, assuming a pessimistic growth rate of 1% per month,
Develop your Model is EXCEL. your report should be in WORD. For the e-Travel guide company, assuming a pessimistic growth rate of 1% per month, develop the cash flow statements, and Profit / Loss statements for the first three years. -Travel Travel Guide Book Sales Assumptions Optimistic Growth rate: 30% Pessimistic Growth rate: % Price $15 Sales in month 3 of 80 Sales by Cudit and SALES PROJECTIONS OPTIMISTIC COST PROJECTIONS e-Travel-Travel Guide Book Cost Assumptions: Author: 12% of not seven paid on 15% of mod Credit card charge 1% Rent $1500/men A $41,000 per year 4-year life Depreciation is $1000 per COST PROJECTIONS e-Travel-Travel Guide Book Cost Assumptions: Salaries (monthly) Travel-Travel Guide Book Cont Assumptions: Salaries (monthly) Soc Sec & Other 15% COST PROJECTIONS -Travel-Travel Guide Book Cost Assumptions Marketing monthly) Year 1 (2000); Year 2 (2500) Year 3 (53000) Utilities, supplies, velly) Year 1 (2000); Year 2 (3000) Year 3 (54000) Interest Expense $1000 per month ($100K 12% per year, Interest paid monthly: Principal paid at end of 5 years) Tax: 30% of income before INCOME STATEMENT PROFIT & LOSS STATEMENT
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