WALL STREET PREP EXCEL CRASH COURSE EXAM 2026 LATEST VERSION
COMPLETE TEST BANK WITH 200 QUESTIONS AND 100% CORRECT
ANSWERS WITH EXPLANATIONS
SECTION 1: FINANCIAL MODELING QUESTIONS (Questions 1-50)
Scenario for Questions 1-50
You are analyzing a retail company called "ABC Retail Inc." The financial model
contains the following historical data and assumptions:
Historical Data:
• 2020 Revenue: $10,000,000
• 2021 Revenue: $11,000,000
• 2022 Revenue: $12,100,000
Assumptions for Forecast Period (2023-2027):
• Revenue Growth Rate: 5% per year
• Cost of Goods Sold (COGS): 60% of Revenue
• Operating Expenses (OpEx): 20% of Revenue
• Depreciation & Amortization (D&A): $500,000 per year
• Interest Expense: $200,000 per year
• Tax Rate: 25%
• Capital Expenditures (CapEx): $1,000,000 per year
• D&A as % of CapEx: 50%
Question 1
Using the assumptions above, what is forecast Revenue in 2023?
,A. 12,500,000
B. 12,705,000
C. 13,000,000
D. 12,100,000
CORRECT ANSWER: B
EXPLANATION: Revenue grows at 5% per year. 2022 Revenue was $12,100,000.
2023 Revenue = $12,100,000 × 1.05 = $12,705,000.
Question 2
What is forecast Revenue in 2024?
A. 13,050,000
B. 13,340,250
C. 13,500,000
D. 12,705,000
CORRECT ANSWER: B
EXPLANATION: 2023 Revenue was $12,705,000. 2024 Revenue = $12,705,000 ×
1.05 = $13,340,250.
Question 3
What is forecast Revenue in 2025?
A. 14,000,000
B. 14,007,263
C. 14,500,000
D. 13,340,250
CORRECT ANSWER: B
EXPLANATION: 2024 Revenue was $13,340,250. 2025 Revenue = $13,340,250 ×
1.05 = $14,007,262.50, rounded to $14,007,263.
,Question 4
What is forecast Revenue in 2026?
A. 14,707,626
B. 14,500,000
C. 15,000,000
D. 14,007,263
CORRECT ANSWER: A
EXPLANATION: 2025 Revenue was $14,007,263. 2026 Revenue = $14,007,263 ×
1.05 = $14,707,626.15, rounded to $14,707,626.
Question 5
What is forecast Revenue in 2027?
A. 15,000,000
B. 15,443,007
C. 15,500,000
D. 14,707,626
CORRECT ANSWER: B
EXPLANATION: 2026 Revenue was $14,707,626. 2027 Revenue = $14,707,626 ×
1.05 = $15,443,007.30, rounded to $15,443,007.
Question 6
What is forecast Cost of Goods Sold (COGS) in 2023?
A. 7,000,000
B. 7,500,000
, C. 7,623,000
D. 7,800,000
CORRECT ANSWER: C
EXPLANATION: COGS is 60% of Revenue. 2023 Revenue is $12,705,000. COGS =
$12,705,000 × 0.60 = $7,623,000.
Question 7
What is forecast COGS in 2024?
A. 8,000,000
B. 8,004,150
C. 8,500,000
D. 7,623,000
CORRECT ANSWER: B
EXPLANATION: 2024 Revenue is $13,340,250. COGS = $13,340,250 × 0.60 =
$8,004,150.
Question 8
What is forecast COGS in 2025?
A. 8,404,358
B. 8,500,000
C. 9,000,000
D. 8,004,150
CORRECT ANSWER: A
EXPLANATION: 2025 Revenue is $14,007,263. COGS = $14,007,263 × 0.60 =
$8,404,357.80, rounded to $8,404,358.
COMPLETE TEST BANK WITH 200 QUESTIONS AND 100% CORRECT
ANSWERS WITH EXPLANATIONS
SECTION 1: FINANCIAL MODELING QUESTIONS (Questions 1-50)
Scenario for Questions 1-50
You are analyzing a retail company called "ABC Retail Inc." The financial model
contains the following historical data and assumptions:
Historical Data:
• 2020 Revenue: $10,000,000
• 2021 Revenue: $11,000,000
• 2022 Revenue: $12,100,000
Assumptions for Forecast Period (2023-2027):
• Revenue Growth Rate: 5% per year
• Cost of Goods Sold (COGS): 60% of Revenue
• Operating Expenses (OpEx): 20% of Revenue
• Depreciation & Amortization (D&A): $500,000 per year
• Interest Expense: $200,000 per year
• Tax Rate: 25%
• Capital Expenditures (CapEx): $1,000,000 per year
• D&A as % of CapEx: 50%
Question 1
Using the assumptions above, what is forecast Revenue in 2023?
,A. 12,500,000
B. 12,705,000
C. 13,000,000
D. 12,100,000
CORRECT ANSWER: B
EXPLANATION: Revenue grows at 5% per year. 2022 Revenue was $12,100,000.
2023 Revenue = $12,100,000 × 1.05 = $12,705,000.
Question 2
What is forecast Revenue in 2024?
A. 13,050,000
B. 13,340,250
C. 13,500,000
D. 12,705,000
CORRECT ANSWER: B
EXPLANATION: 2023 Revenue was $12,705,000. 2024 Revenue = $12,705,000 ×
1.05 = $13,340,250.
Question 3
What is forecast Revenue in 2025?
A. 14,000,000
B. 14,007,263
C. 14,500,000
D. 13,340,250
CORRECT ANSWER: B
EXPLANATION: 2024 Revenue was $13,340,250. 2025 Revenue = $13,340,250 ×
1.05 = $14,007,262.50, rounded to $14,007,263.
,Question 4
What is forecast Revenue in 2026?
A. 14,707,626
B. 14,500,000
C. 15,000,000
D. 14,007,263
CORRECT ANSWER: A
EXPLANATION: 2025 Revenue was $14,007,263. 2026 Revenue = $14,007,263 ×
1.05 = $14,707,626.15, rounded to $14,707,626.
Question 5
What is forecast Revenue in 2027?
A. 15,000,000
B. 15,443,007
C. 15,500,000
D. 14,707,626
CORRECT ANSWER: B
EXPLANATION: 2026 Revenue was $14,707,626. 2027 Revenue = $14,707,626 ×
1.05 = $15,443,007.30, rounded to $15,443,007.
Question 6
What is forecast Cost of Goods Sold (COGS) in 2023?
A. 7,000,000
B. 7,500,000
, C. 7,623,000
D. 7,800,000
CORRECT ANSWER: C
EXPLANATION: COGS is 60% of Revenue. 2023 Revenue is $12,705,000. COGS =
$12,705,000 × 0.60 = $7,623,000.
Question 7
What is forecast COGS in 2024?
A. 8,000,000
B. 8,004,150
C. 8,500,000
D. 7,623,000
CORRECT ANSWER: B
EXPLANATION: 2024 Revenue is $13,340,250. COGS = $13,340,250 × 0.60 =
$8,004,150.
Question 8
What is forecast COGS in 2025?
A. 8,404,358
B. 8,500,000
C. 9,000,000
D. 8,004,150
CORRECT ANSWER: A
EXPLANATION: 2025 Revenue is $14,007,263. COGS = $14,007,263 × 0.60 =
$8,404,357.80, rounded to $8,404,358.
