HomeworkLib
Question

Suppose revenues for a small business are $60,000 this year and will grow 9% per year. Design a spreadsheet t compute revenue
math   Advanced-Math   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

WM The ormda andresult are Show be ow i predsheat qr.1 tears, revenue/tirst exceed 10 & 000 .Year Principal rate Amount at end of vear B5+1 B6+1 B7+1 B8+1 B9+1 B10+1 B11+1 B12+1 B13+1 E5 E6 E7 E8 E9 E10 E11 E12 E13 C5*Principal Amount at end of vear 65,400.00 71,286.00 77,701.74 84,694.90 92,317.44 1,00,626.01 1,09,682.35 1,19,553.76 1,30,31

1 0
Add a comment
Know the answer?
Add Answer to:
Suppose revenues for a small business are $60,000 this year and will grow 9% per year....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • A prospective MBA student earns $60,000 per year in her current job and expects that amount...

    A prospective MBA student earns $60,000 per year in her current job and expects that amount to increase by 14% per year. She is considering leaving her job to attend business school for two years at a cost of $40,000 per year. She has been told that her starting salary after business school is likely to be $80,000 and that amount will increase by 14% per year. Consider a time horizon of 10 years, use a discount rate of 9%,...

  • A prospective MBA student earns $60,000 per year in her current job and expects that amount...

    A prospective MBA student earns $60,000 per year in her current job and expects that amount to increase by 9% per year. She is considering leaving her job to attend business school for two years at a cost of $50,000 per year. She has been told that her starting salary after business school is likely to be $85,000 and that amount will increase by 13% per year. Consider a time horizon of 10 years, use a discount rate of 15%,...

  • 17. A business worth $180,000 is expected to grow at 12% per year compounded annually for...

    17. A business worth $180,000 is expected to grow at 12% per year compounded annually for the next 4 years. (a) Find the expected future value. (b) If funds from the sale of the business today would be placed in an account yielding 8% compounded semiannually, what would be the minimum acceptable price for the business at this time? 18. A corporation worth $40 million is expected to grow at 8% per year compounded annually for 5 years. (a) Find...

  • If OpulCars's revenues in Manchester grow by 30% next year, what will their market share be?...

    If OpulCars's revenues in Manchester grow by 30% next year, what will their market share be? Recent Performance (In £ millions) 96.20 58.80 36.70 33.23 11.32 5.73 2014 2015 2016 Gross Profit Total Revenue Share of Revenue by Location Edinburgh Edinburgh 20% London 44% London 39% 31% Rest of U.K. 13% Rest of U.K. 8% Manchester 22% Manchester 23% 2015 2016 Silicon trader THE NEW LUXURY RIDE: OPULENCE IN TRANSPORT by Kevin Harrington Luxury rideshare firm OpulCars prices at 124...

  • You are trying to value ListoFact, a data processing company. The company generated $1 billion in revenues in the most recent financial year and expects revenues to grow 3% per year in perpetuity. It...

    You are trying to value ListoFact, a data processing company. The company generated $1 billion in revenues in the most recent financial year and expects revenues to grow 3% per year in perpetuity. It generated $30 million in after-tax operating income in the most recent financial year and expects after-tax operating margin to increase 1% per year starting from the current year (Year 0) to year 3. After year 3, the margin will stabilize at year 3 levels forever. The...

  • ABC Corporation is experiencing rapid growth. Dividends are expected to grow at 25% per year during...

    ABC Corporation is experiencing rapid growth. Dividends are expected to grow at 25% per year during the next three years, 15% over the following year and then 6% per year indefinitely. The required return on this stock is 9% and the stock currently sells for $79 per share. What is the projected dividend for the second year?   please use excel

  • Suppose an engineer leaves her $100,000 per year job to start a consulting business. Assume she...

    Suppose an engineer leaves her $100,000 per year job to start a consulting business. Assume she borrows all of the money needed to start the business. In the first-year revenue is $500,000, the salaries paid to employees total $300,000 and the interest paid on the loan is $50,000. The economic profit of the firm is, therefore, $150,000. Is this true, false, or uncertain? If so please explain in detail why.

  • Ionic Charge, is a newly organized manufacturing business that plans to manufacture and sell 60,000 units per year of a new product.

    Ionic Charge, is a newly organized manufacturing business that plans to manufacture and sell 60,000 units per year of a new product. The following estimates have been made of the company’s costs and expenses (other than income taxes). FixedVariableper UnitManufacturing costs:Direct materials$25Direct labor15Manufacturing overhead$500,0008Period costs:Selling expenses2Administrative expenses300,000Totals$800,000$50 Required:a. What should the company establish as the sales price per unit if it sets a target of earning an operating income of $700,000 by producing and selling 60,000 units during the first year of operations? (Hint:...

  • (1 point) Suppose that t years from now, one investment plan will be generating profit at the rat...

    (1 point) Suppose that t years from now, one investment plan will be generating profit at the rate of P (1) = 90 + 12 hundred dollars per year, while a second investment will be generating P(I) = 258 + 21 hundred dollars per year. a. For how many years does the rate of profitability of the second investment exceed that of the first? Answer: b. Compute the net excess profit, in hundreds of dollars, assuming that you invest in...

  • Ashley runs a small business that makes snow skis. She expects the business to grow substantially...

    Ashley runs a small business that makes snow skis. She expects the business to grow substantially over the next three years. Because she is concerned about product liability and is planning to take the company public in year 2, she currently is considering incorporating the business. Pertinent financial data are as follows: Year 1 Year 2 Year 3 Sales revenue $150,000 $320,000 $600,000 Tax-free interest income 5,000 8,000 15,000 Deductible cash expenses 30,000 58,000 95,000 Tax depreciation 25,000 20,000 40,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT