Product Support: FAQ

Find the answer...

BizPlanBuilder v9

Fix: "$VALUE!" in the Comprehensive Financial Model

No big deal.

The problem is in the 'Assumptions - Other' worksheet

(There is a note behind the cell 'Interest Expense' (A17) that explains what to do...)

Here it is:

First, enter the month during your first fiscal year when you expect interest expense to begin. If you do not expect to pay interest expense enter the first month of your first fiscal year. This field must be properly filled in for the interest expense calculations to work. If you get a #VALUE! error, verify that this date falls within your first fiscal year. This is an easy oversight, but an easy fix.

Next, enter the dollar amount for your first month of interest expense.

Now you can enter either a growth %, a monthly increase/decrease, both or neither in the two adjacent cells. The first year interest expense will calculate based on these parameters.

The next task is to enter appropriate growth percentages for the remaining years if applicable.

As always, we appreciate hearing your Success Stories as well as your Suggestions & Feedback.

Other Answers to BizPlanBuilder Frequently Asked Questions (FAQs)

Click Here