How to Calculate Net Present Values in Excel

Introduction Net Present Value (NPV) is a widely used financial metric that helps investors and business managers to evaluate the profitability of an investment or project. NPV calculates the difference between the present value of cash inflows and the present value of cash outflows over a certain period. A positive NPV indicates that the investment … Read more

Excel Tips and Tricks for Financial Modeling

Financial modeling is an essential skill for finance professionals, allowing them to project financial performance, evaluate investment opportunities, and make informed decisions. Microsoft Excel is the go-to software for building financial models, thanks to its flexibility, functionality, and ease of use. In this blog post, we’ll share tips and tricks for maximizing efficiency and accuracy … Read more

Add a New Line in a C# or Visual Basic TextBox

If you’re building a Windows Form Application, for example with C# or Visual Basic, then you may need to add a new line character, for example in a multiline TextBox. You do this using Environment.NewLine to insert the line break as follows: textBox1.Text = “First Line” + Environment.NewLine + “Second Line”; My preferred use is … Read more

Categories C#

Shortcut Key to Paste Values in Excel

If you came here looking for an easy shortcut key to paste values in Excel then it’s bad news I’m afraid – there just isn’t a simple keyboard shortcut in the same way there is to cut, copy or paste normally. However there is a way to paste values using the keyboard, which this tip … Read more

Output HTML From Your PHP Script

In this tutorial, I’ll show you how to output HTML from a PHP script. This is very similar to our tutorial on outputting text using PHP (for example, creating your first script to output the text “hello world”), but we’ll be looking at HTML. HTML is the language of the web, so you’ll encounter it … Read more

Categories PHP

Add Notepad To Your SendTo Menu

In this tutorial, we’ll show you how to add Notepad to the Windows “Send To” menu. What I’ve always found useful since I started using Windows is to add Notepad to the “Send To” menu, which is available when you right click on any file in Windows. This means that if you come across a … Read more

Dynamically Add Text to Image in PHP

This tutorial will tell you how to dynamically write text to an image in PHP. This is fairly simple, so it will just be the first step in a series of tutorials dealing with images in PHP. The image functions require the GD library to be installed. Adding text to a blank dynamically generated image … Read more

Categories PHP

Generate a Month Calendar in PHP

This article shows you how to display a calendar for a given month, mainly using PHP’s date() function. The date() function The date() function displays the date in your desired format, at a given time. It works by accepting one or two parameters, the first is a string with the format, the letters in the … Read more

Categories PHP

Display the Weekday as Text in Excel

I often want to know what day of the week a date is. The obvious choice in Excel is the WEEKDAY() function for this; however it only returns an integer. For example, the formula: =WEEKDAY(“01/02/2009”) returns 1 (which represents Sunday). In this article, I’ll describe the various ways which you can display the weekday as … Read more

Raise a Number to a Power in PHP

You might need to raise a number to the power of another (the exponent) in a PHP script, for example \(2^3=2×2×2\) (sometimes written \(2^3\)), or in general \(x^n\). This may also be used with negative powers where \(x^{−n}=\frac{1}{x^n}\). Of course, you’d probably want to do this for more complicated examples! There are two ways to … Read more

Categories PHP