Content video games direct is modeling out next five years

Assignment Help Financial Management

Reference no: EM131444290

Create Spreadsheet on excel Content Video games direct is modeling out the next 5 years of revenues, expenses and profits based on the following assumptions: Revenue = $100,000 in year 1 and expected to grow 10%/year through year 5 Expenses = $50,000 in year 1 and expected to leverage 120 bps (i.e. 1.2%)/year through year 5 Use the following format:

Driver year1 year 2 year 3 year 4 year 5 total CAGR maximum average median minimum

%--- Revenue

less:expenses

net income

%----- expenses%revenue

Reference no: EM131444290

Questions Cloud

What is the money payment for this car loan : Cosmo Costanza just took out a $34000 bank loan to help purchase his dream car. The bank offered a 5 year loan at a 9% APR. The loan will feature monthly payments and monthly compounding of interest. what is the money payment for this car loan?

What is the forecasted gross profit and operating income : Jose Tine owns Sugar Cane Alley, a small candy shop in Aspen, Colorado. He would like to expand his business and open a second store in Vail. Mr. Tine does not have the capital to undertake this project and would like to borrow the money from the loc..

What is the stocks value per share : Corporate valuation Smith Technologies is expected to generate $100 million in free cash flow next year, and FCF is expected to grow at a constant rate of 5% per year indefinitely. Smith has no debt or preferred stock, and its WACC is 11%. If Smith h..

By how much would the bonds price change : A $1,000 par value bond with seven years left to maturity pays an interest payment semiannually with a 6 percent coupon rate and is priced to have a 5.5 percent yield to maturity. If interest rates surprisingly increase by 0.5 percent, by how much wo..

Content video games direct is modeling out next five years : Create Spreadsheet on excel Content Video games direct is modeling out the next 5 years of revenues, expenses and profits based on the following assumptions: Revenue = $100,000 in year 1 and expected to grow 10%/year through year 5 Expenses = $50,000..

Determine the fair present value of the bond : BSW Corporation has a bond issue outstanding with an annual coupon rate of 5.2 percent paid quarterly and four years remaining until maturity. The par value of the bond is $1,000. Determine the fair present value of the bond if market conditions just..

Yield curve in the wall street journal : You note the following yield curve in The Wall Street Journal. According to the unbiased expectations theory, hat is the 1-year forward rate for the period beginning one year from today, 2f1?Yu note the following yield curve in The Wall Street J You ..

What is required rate of return : Preferred stock valuation Fee Founders has perpetual preferred stock outstanding that sells for $38.00 a share and pays a dividend of $4.00 at the end of each year. What is the required rate of return?

Calculate the fair present values of the bonds : Calculate the fair present values of the following bonds, all of which pay interest semiannually, have a face value of $1,000, have 10 years remaining to maturity, and have a required rate of return of 15.5 percent. The bond has a 7.2 percent coupon ..

User Account

All Pages