![how to use goal seek excel irr real estate how to use goal seek excel irr real estate](https://miro.medium.com/max/1400/1*6fcNRizVhTNZqQapSdx4Lw.png)
He wants to find the interest rate which will help him to attain the desired return. The person now wants to increase the return amount to $ 1500000, but he does not want to increase the time period of investment as well as an initial investment amount. So to find out the return, the person uses the FV function (procedure of calculation is shown in the above figure). The rate of interest is 6.5 %, and the number of years is for 5 years. The bank employee suggested he open a Fixed Deposit Account. In the above figure, a person wants to invest a lump sum amount in his bank for a certain period of time. Now let us take another example Example #4 As a result, the Equated Monthly Instalment (EMI) decreased to Rs. Goal Seek lowers the monthly payment, the number of payments in cell B4 changes from 45 to 82.90.In the Goal Seek Dialog Box, select B6 in the ‘ Set Cell.’.Click on What if Analysis, drop-down menu.So, to achieve this, the person needs to go for Goal Seek. However, he does not want to increase the total amount of repayment by more than Rs 25000. Now he wants to increase the number of repayment periods as he would not be able to pay Rs 481.32 per month. When he calculated the total amount, which he will be repaid in 45 months, he got Rs 21659.47 as a result.
![how to use goal seek excel irr real estate how to use goal seek excel irr real estate](https://www.exceldemy.com/wp-content/uploads/2018/06/Calculate-IRR-Excel-4.png)
He has been told that the loan amount will be sanctioned at an interest rate of 10% per annum for a period of 45 months, which makes the repayment of Rs 481.32 per month. In the above figure, a person has taken a loan amount of Rs 18000. So the Profit value (Revenue – Fixed Cost + Variable cost) needs to be zero to attain break-even value. of generators that can be sold, which will return the break-even value (No Profit No Loss).
How to use goal seek excel irr real estate generator#
It is identified that the maximum price for which a generator can be sold is Rs.
![how to use goal seek excel irr real estate how to use goal seek excel irr real estate](https://i0.wp.com/www.kahrrealestate.com/wp-content/uploads/2017/03/excel.png)
We can see that the company is suffering a loss of 13.8 lacs. The price of each generator is Rs 18000, and the quantity sold is 100 nos.