Jun 21 2022 09:14 PM - edited Jun 22 2022 11:30 AM
I tried to calculate and instead it gives me a negative #, using the formula =B1+NPV(B7,B2:B6) for:
The answer should be 16,312,073 and not the one that's showing as (22,760,060.76).
Jun 22 2022 01:15 AM
Negative numbers aren't showing with parentheses in Excel
f you're using Excel and negative numbers aren't displaying with parentheses, you can change the way negative numbers are displayed. But if that doesn't work, or if the parentheses option ($1,234.10) isn't available, it's likely because an operating system setting isn't set properly. If you're using a Mac, make sure you use the App Store and update to the latest version of macOS. If you're using Windows, use one of the following solutions to change the negative number format. Keep in mind that changing the setting will affect all programs on your computer, not just Excel.
Jun 22 2022 11:14 AM
Jun 22 2022 03:37 PM - edited Jun 22 2022 03:40 PM
@Yabis_Mannmentions wrote: ``formula is =B1+ NPV(B7+B2:B6)``
No, it isn't. It is as you wrote it the first time, to wit: =B1+NPV(B7,B2:B6) .
-----
@Yabis_Mannmentions wrote: ``The answer should be 16,312,073``
Who says?!
You wrote: ``after following the instructions ....``
It might be helpful if you provided a copy of the instructions.
Ideally, do not retype them yourself. We all make mistakes.
If the instructions are provided in a file, attach the file; or upload it to a file-sharing website, and post the download URL. I like box.net/files; others like dropbox.com. The download URL should not require that we log in.
Alternatively, take a photo of the instructions and provide that image file.
-----
@Yabis_Mannmentions wrote: ``I am getting (22,760,060.76). Why is that?``
Because that is the correct result (well, one of two possible results) for the cash flows that you posted.
The following demonstrates the calculations. Note that my cell references are different because I inserted a row with column titles.
Jun 25 2022 04:44 AM
Jun 25 2022 12:21 PM
Jun 25 2022 04:22 PM - edited Jun 26 2022 07:22 AM
@Yabis_Mannmentions wrote: ``After five years, the subsidiary would be sold to Indian investors for Rs110,000,000.``
Formulas:
D2: =B2+C2
D9: =NPV(23%, D3:D7) + D2
D10: =IRR(D2:D7)
That applies to Question #A.
I do not believe you provide sufficient information for us to answer Question #B, namely ``the rupee/dollar exchange rate on December 31st for the next six years are listed in the popup table``.
But I believe the following demonstrates the calculations.
Note: Calculated amounts might differ due to rounding.
Formulas:
G3: =IF(B3="", "", B3/F3)
H3: =IF(C3="", "", C3*85%/F3)
I3: =SUM(G3, H3)
I10: =NPV(23%, I4:I8) + I3