File Name

Goal_Seek_Practice.xlsx

Part A — Profit Analysis

Input	Value
Quantity	200
Selling Price	500
Cost per Unit	300
Fixed Cost	10000

Tasks

1. Calculate Revenue.
2. Calculate Variable Cost.
3. Calculate Total Cost.
4. Calculate Profit.
5. Use Goal Seek to achieve ₹50,000 profit by changing Selling Price.
6. Reset the model.
7. Use Goal Seek to achieve ₹50,000 profit by changing Quantity.

Part B — Loan Analysis

Input	Value
Loan Amount	500000
Annual Interest	10%
Loan Period	5 Years

Calculate monthly EMI using:

=PMT(B3/12,B4*12,-B2)

Task

Use Goal Seek to find a loan period that produces approximately:

₹10,000 monthly EMI

Part C — Investment Analysis

Input	Value
Monthly Investment	8000
Annual Return	8%
Investment Period	5 Years

Future Value:

=FV(B3/12,B4*12,-B2,0)

Task

Use Goal Seek to determine the monthly investment required for a target future value of:

₹10,00,000

Final Challenge

Create a Goal Seek Business Calculator with three sections:

Profit Target

• Quantity
• Selling Price
• Cost
• Fixed Cost
• Target Profit

Loan Target

• Loan Amount
• Interest Rate
• Loan Period
• Target EMI

Investment Target

• Monthly Investment
• Interest Rate
• Period
• Target Future Value

Use Goal Seek to solve each target.