Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 3

blur-text-image

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

Intelligent Accountant Strategies Concepts And Ideas To Transform Your Practice

Authors: Darren Gleeson

1st Edition

1925515575, 978-1925515572

More Books

Students also viewed these Accounting questions

Question

LO6 Describe how individual pay rates are set.

Answered: 1 week ago