BasicFinance - MSI Company

This is a timed test, Answer as many questions as you can in 5 minutes. Questions CAN"T be Skipped.

Name

First

Last

Email

Question 1 – Gross Margin: A company sells a product for $120. The cost to produce it is 72. What is the gross margin percentage?

30%
40%
48%
60%

Question 2 – Profit Calculation: A company has revenue $500,000 Cost of Goods Sold $320,000 Operating Expenses $110,000 What is the net profit?

$70,000
$80,000
$90,000
$110,000

Question 3 – Break Even: A product sells for $50 each. Variable cost per unit $30 Fixed costs $400,000 How many units must be sold to break even?

Question 4 – Time Value of Money: You receive $1000 today or $1000 in 2 years. Which is financially better assuming positive interest rates?

$1000 today
$1000 in two years
They are equal
Cannot determine

Question 5 – ROI: You invest $5000 in a project and receive $6500 after one year. What is the ROI?

15%
20%
30%
35%

Question 6 – Excel VLOOKUP: A VLOOKUP function is primarily used to?

Summarize data in rows and columns
Find and return data from another table based on a matching value
Create charts automatically
Sort large datasets

Question 7 – Pivot Tables: What is the main purpose of a Pivot Table in Excel

Writing formulas automatically
Organizing and summarizing large datasets
Creating macros
Importing data from other systems

Question 8 – Financial Statement Logic: Which financial statement shows a company's assets liabilities and equity at a specific point in time?

Income Statement
Balance Sheet
Cash Flow Statement
Statement of Retained Earnings

is it Even:

Question 9 – Data Interpretation: A company's revenue grew from $2,000,000 to 2,500,000 in one year. What was the growth rate?

20%
22%
25%
30%

Question 10 – Excel Logic: If you wanted to summarize total sales by region from a dataset with 10,000 rows which Excel feature would be the best tool?

Pivot Table
VLOOKUP
Conditional Formatting
Data Validation