Question
SM.61 A small but growing online retailer, Nile Corporation, has shown impressive growth in sales over the past several years, with sales this past year
SM.61 A small but growing online retailer, Nile Corporation, has shown impressive growth in sales over the past several years, with sales this past year at $1,043,000. If the company has a net profit margin of 4.25 percent, what would its net profit be (in dollars)? (Display your answer as a whole number.) If in the next year the company achieves its revenue growth target of 8 percent, what would its total revenue be? (Display your answer as a whole number.) If in the next year the company achieves its revenue growth target of 8 percent, and assuming its profit margin remained unchanged at 4.25 percent, what would its total profit be for next year? (Display your answer as a whole number.) If the company achieves its revenue growth target of 8 percent, by how many dollars will revenue increase? (Display your answer as a whole number.)
If the company achieves its revenue growth target of 8 percent, by how many dollars will net profit increase? (Display your answer as a whole number.)
Using the original revenue number of $1,043,000, if the company spends 58 percent of its revenue on purchases, what would be its purchasing expense? (Display your answer as a whole number.)
Assuming that revenues stayed flat (meaning the company did not try to increase sales by the 8 percent target), by what percentage would they have to decrease purchasing expenses to equal the increased profit that would have come from a 8 percent increase to revenues? (Write your answer as a percentage, and display your answer to two decimal places.) %
Please show how to calculate through excel. Thanks!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started