Annual Compound Formula is:
A = P( 1 + r/n) ^nt
Where:
A is the future value of the investment
P is the principal investment
r is the annual interest rate
<span>n is the number of
interest compounded per year</span>
t is the number of years the money is invested
So for the given problem:
P = $10,000
r = 0.0396
n = 2 since it is semi-annual
t = 2 years
Solution:
A = P( 1 + r/n) ^nt
A = $10,000 ( 1 + 0.0396/2) ^ (2)(2)
A = $10000 (1.00815834432633616)
A = $10,815.83 is the amount after two years
Answer:
The closing balance from the excel sheet is $5,000.00
Explanation:
Solution
Given that:
The loan balance required l for each month can be computed as follows:
The loan balance = additional cash needed – cash used to retire debt + loan balance from previous month
Now
By applying the excel formula to perform this task is stated as follows:
D34 = SUM(D31-D33,C34)
The same formula is used to get the values for E34 to I34.
Kindly find an attached copy of the updated excel sheet after applying above formula which is a part of the solution is as follows:
Answer:
The change in net working capital resulting from the addition of the microbrewery is $5,500 (decrease)
Explanation:
There are 3 key elements of working capital. These are;
- Inventory
- Accounts payable
- Accounts receivable
Given;
increase in inventory = $8,000
increase in Accounts payable = $2,500
Change in net working capital resulting from the addition of the microbrewery = -$8,000 + $2,500
= -$5,500