Compute gross profit revenue less fixed and variable costs

Assignment Help Financial Management

Reference no: EM132071453

Suppose a small business has sales of $11,000 this month, with future sales expected to grow by $1,300 each month. Costs consist of a fixed component, which is $5,500 per month, and a variable component, which is 30 percent of sales. Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period. What is the gross profit in a single month 8 months from now? Please specify your answer as an integer.

Reference no: EM132071453

Questions Cloud

Payment you will have to make in one year will be : If you borrow $1,000 today to be paid back one year from today at 5% interest, the payment you will have to make in one year will be

Explain the shape of each of the three curves : Explain the shape of each of the three curves you obtain in part b.

What is the goal of financial management : What is an initial public offering (IPO)? What is the goal of financial management? Why do you think this is important?

Functional level to improve post efficiency-product quality : The functional level to improve Post's efficiency, product quality, ability to innovate, and responsiveness to our customers.

Compute gross profit revenue less fixed and variable costs : Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period.

Issues of structure and cost of capital : Provide a discussion of the impact of each alternative which would include issues of structure and cost of capital.

Used on the basis of present worth analysis : At an interest rate of 10% per year, which method should be used on the basis of a present worth analysis?

What is the difference in their current prices : If the required rate of return on both bonds is 7 percent compounded semi-annually, what is the difference in their current prices?

Describe the tax shield advantage debt capital provides : Calculate the current cost of capital of Secure and Safe on a weighted average basis. describe the tax shield advantage debt capital provides.

User Account

All Pages