Dynama+ Dynama - Revision history

Breedcowadmin: /* Data Tables 1 to 6 - Deaths, Calving and Prices */

2023-06-05T23:49:50Z

Data Tables 1 to 6 - Deaths, Calving and Prices

FinlayV: /* Step 5 Complete the Dynama worksheet */

2020-08-26T03:52:13Z

Step 5 Complete the Dynama worksheet

FinlayV: /* Step 5 Complete the Dynama worksheet */

2020-08-26T03:47:53Z

Step 5 Complete the Dynama worksheet

FinlayV: /* Compile reports and review results */

2020-08-26T03:46:46Z

Compile reports and review results

FinlayV: /* Table 10(b) Projections */

2020-08-26T03:45:17Z

Table 10(b) Projections

FinlayV: /* Table 10(b) Projections */

2020-08-26T03:43:50Z

Table 10(b) Projections

FinlayV: /* Loans Table 10(a) Loan Terms */

2020-08-26T03:41:45Z

Loans Table 10(a) Loan Terms

FinlayV: /* Paying interest in advance in Dynama+ */

2020-08-26T03:32:40Z

Paying interest in advance in Dynama+

FinlayV: /* Compile reports and review results */

2020-08-26T03:32:08Z

Compile reports and review results

FinlayV: /* Compile reports and review results */

2020-08-26T03:30:10Z

Compile reports and review results

@@ Line 10: / Line 10: @@
 The first four data tables in the Dynama worksheet only require entries for the first year if values are expected to remain the same over time. Year one are normal data entry cells (black text). Years two to ten are automatically generated (red-brown text) and allow new entries to be over typed. These formulas copy the initial values to the second and subsequent years in each table but may be overridden with value entries if later years are expected to have different values to the first year.
-[[file:Data Table 1.PNG|frame|center|Female death rates table from Dynama worksheet.The values entered for annual death rates are automatically copied to the remaining years of the program unless they are overwritten. The values shown for death rates are the same as those used in the Breedcow+ example file.]]
+[[file:Data Table 1.PNG|frame|center|Female death rates table from Dynama worksheet. The values entered for annual death rates are automatically copied to the remaining years of the program unless they are overwritten. The values shown for death rates are the same as those used in the Breedcow+ example file.]]
 [[file:Data Table 2.PNG|frame|center|Male death rates from Dynama worksheet. This table shows the death rates for all males that are entered into Table 2 of the Dynama worksheet. Herd bull death rates are transferred to HERD TABLE 7. It must be remembered that stock that are purchased and sold in the same year will not have a death rate applied against the opening number as this class of stock is not “carried” for the entire year. Adjustment to sale prices or weights may have to be made if significant losses occur in purchased stock.]]

← Older revision		Revision as of 03:52, 26 August 2020
Line 1:		Line 1:
−	==Step 5 Complete the Dynama worksheet==	+	==Step 6 Complete the Dynama worksheet==

	The Dynama worksheet automatically takes values from the Dynama+ [[Dynama+ AECalc\|AECalc]], [[Dynama+ Prices\|Prices]], [[Dynama+ Huscosts\|Huscosts]] and [[Dynama+ Assets\|Assets]] worksheets and combines them with data about births, losses, sales and purchases to build a ten year sequence of livestock schedules.		The Dynama worksheet automatically takes values from the Dynama+ [[Dynama+ AECalc\|AECalc]], [[Dynama+ Prices\|Prices]], [[Dynama+ Huscosts\|Huscosts]] and [[Dynama+ Assets\|Assets]] worksheets and combines them with data about births, losses, sales and purchases to build a ten year sequence of livestock schedules.

@@ Line 1: / Line 1: @@
 ==Step 5 Complete the Dynama worksheet==
-The Dynama worksheet automatically takes values from the Dynama+ [[Dynama+ AECalc|AECalc]], [[Dynama+ Prices|Prices]] and [[Dynama+ Huscosts|Huscosts]] worksheets and combines them with data about births, losses, sales and purchases to build a ten year sequence of livestock schedules.
+The Dynama worksheet automatically takes values from the Dynama+ [[Dynama+ AECalc|AECalc]], [[Dynama+ Prices|Prices]], [[Dynama+ Huscosts|Huscosts]] and [[Dynama+ Assets|Assets]] worksheets and combines them with data about births, losses, sales and purchases to build a ten year sequence of livestock schedules.
 A livestock schedule (Dynama HERD TABLE 7) provides a snapshot of the structure and productivity of a cattle herd for up to a decade.

← Older revision		Revision as of 03:46, 26 August 2020
Line 272:		Line 272:

	Unlike the Breedcow+ program, where the number of most interest was the gross margin, the Dynama+ program produces a large range of indices and outputs that can be used to investigate the future performance of a beef business in both a physical and financial sense.		Unlike the Breedcow+ program, where the number of most interest was the gross margin, the Dynama+ program produces a large range of indices and outputs that can be used to investigate the future performance of a beef business in both a physical and financial sense.
−
−	~~Nineteen preformatted reports are available in the Dynama worksheet to help view all the aspects of the performance of the beef business.~~

	The livestock schedule contained within Table 7 of the Dynama worksheet indicates the expected future performance of every class of cattle to be run by the property. The financial information entered into the worksheets will combine with the physical performance of the herd schedule to indicate the viability of the business and its capacity to service debt over time.		The livestock schedule contained within Table 7 of the Dynama worksheet indicates the expected future performance of every class of cattle to be run by the property. The financial information entered into the worksheets will combine with the physical performance of the herd schedule to indicate the viability of the business and its capacity to service debt over time.

@@ Line 218: / Line 218: @@
 [[file: Loan Table 10b.PNG|frame|center|Extract from example file of term loan projections]]
-All data in Table 10(b) of the Dynama worksheet is generated by formulas, though the values for payments this year and interest rate are calculated by allow override formulas. Interest rates can be changed during the budget period, or repayments reduced or increased.
+All data in Table 10(b) of the Dynama worksheet is generated by formulas, though the values for payments this year and interest rate are calculated by allow override formulas. '''''Interest rates can be changed during the budget period, or repayments reduced or increased.'''''
-The value for the interest rate in the first year of Table 10(b) is copied by an allow override formula linked to Table 10(a). For the second year of Table 10(b), the source is year one of Table 10(b). In the third year the source is year two etc. Thus an interest rate override will flow through to all later years. Conversely, changes made to the value allocated to payments this year does not flow through to later years.
+The value for the interest rate in the first year of Table 10(b) is copied by an allow override formula linked to Table 10(a). For the second year of Table 10(b), the source is year one of Table 10(b). In the third year the source is year two etc. Thus an interest rate override will flow through to all later years. Conversely, changes made to the value allocated to '''payments this year''' does not flow through to later years.
 For new loans, the formula determines how many payments will be made between the starting date of the loan and the end of the year and uses that to calculate the value for payments that year.

@@ Line 214: / Line 214: @@
 ====Table 10(b) Projections====
-Table 10(b) of the Dynama worksheet restates the opening balances and interest rates, calculates total payments for the year from Table 10(a) and then works out the interest component and calculates closing balances. These calculations are then carried on for the whole ten years of the budget.
+Table 10(b) of the Dynama worksheet restates the opening balances and interest rates, calculates total payments for the year from Table 10(a) and then works out the interest component and calculates closing balances. These calculations are then carried on for the whole ten years of the budget. The example below shows that in the next year the business will reduce the loan from $250,000 to $230,981 and pay $15,040 in interest. These calculations are repeated for each year of life of the loan.
 [[file: Loan Table 10b.PNG|frame|center|Extract from example file of term loan projections]]

@@ Line 194: / Line 194: @@
 The second last block of Table 9 of the Dynama worksheet shows debt and interest (sourced from Table 10), total assets, net worth, cash flow and net income.
-===Loans Table 10(a) Loan Terms===
+===Loans Tables 10===
 This table calculates a loan repayment based on the opening balance of term loans, payments per year, the amount of each payment, and the nominal interest.
 Table 10(a) of the Dynama worksheet is for loans with regular repayments and interest paid in arrears. For loans on which interest is paid in advance see the notes later in this section.
@@ Line 210: / Line 215: @@
 Table 10(b) of the Dynama worksheet restates the opening balances and interest rates, calculates total payments for the year from Table 10(a) and then works out the interest component and calculates closing balances. These calculations are then carried on for the whole ten years of the budget.
 All data in Table 10(b) of the Dynama worksheet is generated by formulas, though the values for payments this year and interest rate are calculated by allow override formulas. Interest rates can be changed during the budget period, or repayments reduced or increased.
@@ Line 230: / Line 237: @@
 Interest calculated on working accounts of Table 10 is only approximate, being based on the average of the opening and closing balances. Interest is charged on debit accounts but not credited to debit accounts in credit.
 ===Paying interest in advance in Dynama+===

@@ Line 237: / Line 237: @@
 With interest paid in advance, such as with a bank bill, the nominal borrowing may be $100,000 at 10 percent, but the 10 percent would come out at the start of the loan. Thus $100,000 is received, but $10,000 goes straight back as interest.
-'''''The calculations in Dynamaplus are not designed to handle this type of interest calculation;''''' however some makeshift adaptations are possible.
+'''''The calculations in Dynama+ are not designed to handle this type of interest calculation;''''' however some makeshift adaptations are possible.
 For an existing interest-in-advance loan with annual payments of interest only, enter the opening balance and the interest rate, e.g. $100,000 at 10 percent and one payment per year of $10,000.
@@ Line 259: / Line 259: @@
 Note that the entries made under '''Interest Rat'''e are a means to an end – mainly getting the correct display of interest amount - and differ markedly from the original 10 percent because of the totally different basis and time scale upon which interest is being calculated.
 ==Compile reports and review results==

← Older revision		Revision as of 03:32, 26 August 2020
Line 276:		Line 276:

	For example, if two significant droughts have been encountered in the last decade, the costs and loss of animal performance associated with such events need to be accounted for in a budgeting process that looks forward a decade. Likewise, the potential impact of the fluctuation in prices received for sale stock over recent decades can to be tested in the budget by substituting a range of sale prices (high, medium and low) in the Prices worksheet. Even though low prices are unlikely to be encountered for a full decade, it is possible to consider the capacity of the business to survive and meet its commitments in the short to medium term if a sudden fall were to occur.		For example, if two significant droughts have been encountered in the last decade, the costs and loss of animal performance associated with such events need to be accounted for in a budgeting process that looks forward a decade. Likewise, the potential impact of the fluctuation in prices received for sale stock over recent decades can to be tested in the budget by substituting a range of sale prices (high, medium and low) in the Prices worksheet. Even though low prices are unlikely to be encountered for a full decade, it is possible to consider the capacity of the business to survive and meet its commitments in the short to medium term if a sudden fall were to occur.
		+
		+	[[file: Outcomes.PNG\|frame\|center\|A snapshot of the ten year Dynama+ model. Trends over time in grazing pressure applied, the balance of working accounts, debt and net worth for the business can be followed.]]

@@ Line 269: / Line 269: @@
 The livestock schedule contained within Table 7 of the Dynama worksheet indicates the expected future performance of every class of cattle to be run by the property. The financial information entered into the worksheets will combine with the physical performance of the herd schedule to indicate the viability of the business and its capacity to service debt over time.
-he Dynama+ program allows the careful consideration of the impact of a sudden financial shock like the loss of an important market or an extreme weather event and can quickly plot the capacity of the business to recover from the shock.
+The Dynama+ program allows the careful consideration of the impact of a sudden financial shock like the loss of an important market or an extreme weather event and can quickly plot the capacity of the business to recover from the shock.
 Conversely, improvement strategies that need time and resources to implement can also be planned out in a detailed way to consider any impacts on the physical and financial performance of the business over time.