Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12. A company has revenue of $1000 in 2009. Our current estimate is that revenues will grow 25% per year. Our profit each year will

12. A company has revenue of $1000 in 2009. Our current estimate is that revenues will grow 25% per year. Our profit each year will equal 20% of revenue. What is the total value (rounded to the nearest dollar) of all revenues earned during the years 2009-2015? Enter just the number; e.g., 18491 13. A company has revenue of $1000 in 2009. Our current estimate is that revenues will grow 25% per year. Our profit each year will equal 20% of revenue. What annual growth rate (rounded to the nearest 1%) in revenue would yield a total profit of $15,000 for years 2009-2015 for this situation. Enter just the number; e.g., 65% 28. You are going to borrow $500,000 to buy a house. Assume an annual interest rate of 8%. The length of the loan is 30 years and you are making payments at the end of each month. Your monthly payment is _____. Enter just the number (no dollar sign), as a positive number, rounded to the nearest dollar; e.g., 4218.5 should be entered as 4219 44. Suppose you have listed Le Napoleon's monthly sales of pear tortes in a twelve-sheet workbook. The first worksheet contains January sales, the second worksheet February sales, etc. The pear torte sales are always listed in cell F7. What multi-sheet (three-dimensional) formula would give the total pear torte sales for the months March-July, inclusive? Assume that each worksheet is named with the month name only, spelled out in full. Include the equal sign at the beginningfor example, =SUM(A1:A24)but do not include any unnecessary spaces or parentheses in your response. Also do not anchor any cellsi.e., do not use any $ characters

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

Hospitals What They Are And How They Work

Authors: Don Griffin, Donald J Griffin

3rd Edition

076372758X, 9780763727581

More Books

Students also viewed these Accounting questions