VIPSolutionsPlease help with cells Red for the investment amount and the proforma statment intrest is not 4 0 0 0 0 and investment amount is not 9 4 7 0 0 0a B [+ D 1 Project Information 2 EE 700,000 5 [ee 15,000 PR ~=cion cost 776,000 fl Annual Sales 439,000 [al crease in Sales of Existing Product 50,000 ll Arai Cost 100,000 [il Depreciaied Suezightine 10 200,000 over Syears ER 11 =the =nd 136.000 JUN Bond nicest 60.000 | per year Jl rvestmentininvertery in year 0 71,000 RA investment in inventory in succeeding years 1100 13 LEE 357 “ LE What is the investment amount for this project? [a ® Intermediary Calculations hid ® Pro-Forma Statements El Year 1 ri 3 i Sales Fall Cost Pe Depreciation p
Question:
Please help with cells Red for the investment amount and the proforma statment intrest is not
4
0
0
0
0
and investment amount is not
9
4
7
0
0
0
a B [+ D
1 Project Information
2 EE 700,000
5 [ee 15,000
PR ~=cion cost 776,000
fl Annual Sales 439,000
[al crease in Sales of Existing Product 50,000
ll Arai Cost 100,000
[il Depreciaied Suezightine 10 200,000 over Syears
ER 11 =the =nd 136.000
JUN Bond nicest 60.000 | per year
Jl rvestmentininvertery in year 0 71,000
RA investment in inventory in succeeding years 1100
13 LEE 357
“
LE What is the investment amount for this project? [a
® Intermediary Calculations
hid
® Pro-Forma Statements
El Year 1 ri 3
i Sales
Fall Cost
Pe Depreciation
p
This is AI generated Response.
Asked by: Veera manikanta
Created at: 2025-08-11 08:59:35
Asked by: Veera manikanta
Created at: 2025-08-11 08:59:35
Final Answer:
Rendered
Raw Text
Did you like this answer?
Let's break down your request using the provided image:
### 1. **Investment Amount Calculation**
#### Formula:
From the data, the investment amount is typically the initial outflow required to start the project. It generally includes:
- MV of Land
- Engineer Cost
- Factory cost
- Investment in inventory in year 0
##### Values from the image:
- **MV of Land:** 100,000
- **Engineer Cost:** 15,000
- **Factory cost:** 776,000
- **Investment in inventory in year 0:** 71,000
#### **Total Investment Amount Calculation:**
```
= 100,000 (Land)
+ 15,000 (Engineer)
+ 776,000 (Factory)
+ 71,000 (Inventory year 0)
= 962,000
```
So, the investment amount **should be 962,000** (not 947,000 as you mentioned).
---
### 2. **Pro-Forma Statement — Interest**
The "Interest" row (row 24) in your Pro-Forma Statement is highlighted red for Year 1. Let's check why:
- The interest expense is shown in the Project Information as **60,000 per year** (row 9).
- The value in the red cell in row 24, column B (Year 1) is **0**, which is incorrect.
#### **Correction:**
- The interest for each year should be **60,000**.
---
### 3. **Summary Table**
| Item | Correct Value | Shown Value | Correction Needed? |
|----------------------------|--------------|-------------|-------------------|
| Investment Amount | 962,000 | 947,000 | Yes |
| Pro-Forma Statement Interest (Year 1) | 60,000 | 0 | Yes |
---
## **What to Do:**
- **For Investment Amount**: Enter `962,000`
- **For Pro-Forma Interest (Year 1, row 24, col B)**: Enter `60,000`
- **For other years, repeat 60,000 unless otherwise specified.**
---
If you need a formula for Excel:
- **Investment Amount Cell (e.g., B15):**
```
=B2+B3+B4+B11
```
- **Interest in Year 1 (e.g., B24):**
```
=B9
```
Let me know if you need further help with the calculations or formulas!
📢 Instructions:
- Ask anything relatd to above question only.
- For new Question goto :