Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show how you did it on excel, in that way I will understand where the solutionumbers come from. SM.61 A small but growing online

image text in transcribed

Please show how you did it on excel, in that way I will understand where the solutionumbers come from.

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 $921,000. If the company has a net profit margin of 3 percent, what would its net profit be (in dollars)? (Display your answer as a whole number.) Nmero If in the next year the company achieves its revenue growth target of 12 percent, what would its total revenue be? (Display your answer as a whole number.) Nmero If in the next year the company achieves its revenue growth target of 12 percent, and assuming its profit margin remained unchanged at 3 percent, what would its total profit be for next year? (Display your answer as a whole number.) Nmero If the company achieves its revenue growth target of 12 percent, by how many dollars will revenue increase? (Display your answer as a whole number.) Nmero If the company achieves its revenue growth target of 12 percent, by how many dollars will net profit increase? (Display your answer as a whole number.) Nmero Using the original revenue number of $921,000, if the company spends 67 percent of its revenue on purchases, what would be its purchasing expense? (Display your answer as a whole number.) Nmero Assuming that revenues stayed flat (meaning the company did not try to increase sales by the 12 percent target), by what percentage would they have to decrease purchasing expenses to equal the increased profit that would have come from a 12 percent increase to revenues? (Write your answer as a percentage, and display your answer to two decimal places.) %

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

Financial Statements Analysis Cases From Corporate India

Authors: Sandeep Goel

1st Edition

1138663921, 9781138663923

More Books

Students also viewed these Accounting questions

Question

Describe the factors influencing of performance appraisal.

Answered: 1 week ago

Question

What is quality of work life ?

Answered: 1 week ago