Goal seek on excel for mac

broken image
broken image
broken image

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. 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.

broken image

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). It is identified that the maximum price for which a generator can be sold is Rs. We can see that the company is suffering a loss of 13.8 lacs.

broken image

The price of each generator is Rs 18000, and the quantity sold is 100 nos. If A is 9, what will be the second number for B to get the result, 72. In the above figure, there are two numbers, A and B, with the value of 9 and 6, respectively.Ī product is done using the function =PRODUCT(B1,B2), resulting to 54.