$300,000 loan
6% per year APR
30 year armotization
Payable monthly
Paid exactly 5 years
What is the loan balance?
Please show standard factor notation.
Answer should be: $279,163.07
In: Accounting
On January 1, Year 1, a company issues $200,000 of 8%, 5-year bond, dated 1/1/20X1, which matures 1/1/20X6, and must pay interest twice a year (semi-annually) every first of July and first of January. The Cash balance at the end of July 1, 20X3 is:
In: Accounting
1 year(s) ago, Mack invested 5,930 dollars. In 1 year(s) from today, he expects to have 8,330 dollars. If Mack expects to earn the same annual return after 1 year(s) from today as the annual rate implied from the past and expected values given in the problem, then how much does Mack expect to have in 5 years from today?
3 year(s) ago, Carl had 241,900 dollars in his account. In 9 year(s), he expects to have 357,800 dollars. If he has earned and expects to earn the same return each year from 3 year(s) ago to 9 year(s) from today, then how much does he expect to have in 1 year(s) from today?
1 year(s) ago, Fatima invested 6,040 dollars. In 2 year(s) from today, she expects to have 7,660 dollars. If Fatima expects to earn the same annual return after 2 year(s) from today as the annual rate implied from the past and expected values given in the problem, then in how many years from today does she expect to have exactly 10,970 dollars? Round your answer to 2 decimal places (for example, 2.89, 14.70, or 6.00).
In: Finance
Suppose Wall Street securities firms paid out year-end bonuses
of $125,500 per employee last year. We take a sample of employees
at the ASBE securities firm to see whether the mean year-end bonus
is greater than the reported mean of $125,500 for the
population.
You wish to test the following claim (HaHa) at a significance level
of α=0.01α=0.01.
Ho:μ=125500
Ha:μ>125500
You believe the population is normally distributed and you know the
standard deviation is σ=2900σ=2900. You obtain a sample mean of
¯x=126024.1 for a sample of size n=60n=60.
What is the test statistic for this sample?
test statistic = (Report answer accurate to 3 decimal
places.)
What is the p-value for this sample?
p-value = (Report answer accurate to 4 decimal
places.)
The p-value is...
This test statistic leads to a decision to...
As such, the final conclusion is that...
In: Statistics and Probability
| Item | Prior year | Current year |
| Accounts payable | 8,182.00 | 7,934.00 |
| Accounts receivable | 6,069.00 | 6,515.00 |
| Accruals | 1,006.00 | 1,348.00 |
| Cash | ??? | ??? |
| Common Stock | 11,399.00 | 11,474.00 |
| COGS | 12,747.00 | 18,143.00 |
| Current portion long-term debt | 4,958.00 | 4,954.00 |
| Depreciation expense | 2,500 | 2,830.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,233.00 | 4,808.00 |
| Long-term debt | 14,999.00 | 13,878.00 |
| Net fixed assets | 50,074.00 | 54,846.00 |
| Notes payable | 4,341.00 | 9,877.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,378.00 | 29,936.00 |
| Sales | 35,119 | 47,697.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's cash flow from financing?
In: Finance
| Item | Prior year | Current year |
| Accounts payable | 8,182.00 | 7,934.00 |
| Accounts receivable | 6,069.00 | 6,515.00 |
| Accruals | 1,006.00 | 1,348.00 |
| Cash | ??? | ??? |
| Common Stock | 11,399.00 | 11,474.00 |
| COGS | 12,747.00 | 18,143.00 |
| Current portion long-term debt | 4,958.00 | 4,954.00 |
| Depreciation expense | 2,500 | 2,830.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,233.00 | 4,808.00 |
| Long-term debt | 14,999.00 | 13,878.00 |
| Net fixed assets | 50,074.00 | 54,846.00 |
| Notes payable | 4,341.00 | 9,877.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,378.00 | 29,936.00 |
| Sales | 35,119 | 47,697.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's total change in cash from the prior year to the current year?
In: Finance
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
178,480.00 |
|
Depreciation expense |
21,600 |
23,731.00 |
|
Interest expense |
16,200 |
16,751.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
137,821.00 |
|
Net fixed assets |
376,128.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
65,598.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
335,829.00 |
|
Taxes |
9,900 |
19,235.00 |
What is the current year's cash balance? Round to 0 decimal places
In: Finance
| Category | Prior Year | Current Year |
| Accounts payable | 3,163.00 | 5,995.00 |
| Accounts receivable | 6,848.00 | 8,905.00 |
| Accruals | 5,712.00 | 6,134.00 |
| Additional paid in capital | 20,329.00 | 13,508.00 |
| Cash | ??? | ??? |
| Common Stock | 2,850 | 2,850 |
| COGS | 22,048.00 | 18,479.00 |
| Current portion long-term debt | 500 | 500 |
| Depreciation expense | 998.00 | 1,017.00 |
| Interest expense | 1,283.00 | 1,152.00 |
| Inventories | 3,059.00 | 6,713.00 |
| Long-term debt | 16,606.00 | 22,146.00 |
| Net fixed assets | 75,301.00 | 74,269.00 |
| Notes payable | 4,048.00 | 6,512.00 |
| Operating expenses (excl. depr.) | 19,950 | 20,000 |
| Retained earnings | 35,591.00 | 34,308.00 |
| Sales | 46,360 | 45,170.00 |
| Taxes | 350 | 920 |
What is the firm's cash flow from financing?
Round to 0 decimal places
In: Finance
| Chapter 9: Applying Excel | |||||||
| Data | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | 1 | 2 | ||
| Budgeted unit sales | 40,000 | 60,000 | 100,000 | 50,000 | 70,000 | 80,000 | |
| • Selling price per unit | $8 | per unit | |||||
| • Accounts receivable, beginning balance | $65,000 | ||||||
| • Sales collected in the quarter sales are made | 75% | ||||||
| • Sales collected in the quarter after sales are made | 25% | ||||||
| • Desired ending finished goods inventory is | 30% | of the budgeted unit sales of the next quarter | |||||
| • Finished goods inventory, beginning | 12,000 | units | |||||
| • Raw materials required to produce one unit | 5 | pounds | |||||
| • Desired ending inventory of raw materials is | 10% | of the next quarter's production needs | |||||
| • Raw materials inventory, beginning | 23,000 | pounds | |||||
| • Raw material costs | $0.80 | per pound | |||||
| • Raw materials purchases are paid | 60% | in the quarter the purchases are made | |||||
| and | 40% | in the quarter following purchase | |||||
| • Accounts payable for raw materials, beginning balance | $81,500 | ||||||
| Enter a formula into each of the cells marked with a ? below | |||||||
| Review Problem: Budget Schedules | |||||||
| Construct the sales budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | 1 | 2 | ||
| Budgeted unit sales | ? | ? | ? | ? | ? | ? | |
| Selling price per unit | ? | ? | ? | ? | ? | ? | |
| Total sales | ? | ? | ? | ? | ? | ? | |
| Construct the schedule of expected cash collections | Year 2 Quarter | ||||||
| 1 | 2 | 3 | 4 | Year | |||
| Accounts receivable, beginning balance | ? | ? | |||||
| First-quarter sales | ? | ? | ? | ||||
| Second-quarter sales | ? | ? | ? | ||||
| Third-quarter sales | ? | ? | ? | ||||
| Fourth-quarter sales | ? | ? | |||||
| Total cash collections | ? | ? | ? | ? | ? | ||
| Construct the production budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | Year | 1 | 2 | |
| Budgeted unit sales | ? | ? | ? | ? | ? | ? | ? |
| Add desired finished goods inventory | ? | ? | ? | ? | ? | ? | |
| Total needs | ? | ? | ? | ? | ? | ? | |
| Less beginning inventory | ? | ? | ? | ? | ? | ? | |
| Required production | ? | ? | ? | ? | ? | ? | |
| Construct the raw materials purchases budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | Year | 1 | ||
| Required production (units) | ? | ? | ? | ? | ? | ? | |
| Raw materials required to produce one unit | ? | ? | ? | ? | ? | ? | |
| Production needs (pounds) | ? | ? | ? | ? | ? | ? | |
| Add desired ending inventory of raw materials (pounds) | ? | ? | ? | ? | ? | ||
| Total needs (pounds) | ? | ? | ? | ? | ? | ||
| Less beginning inventory of raw materials (pounds) | ? | ? | ? | ? | ? | ||
| Raw materials to be purchased | ? | ? | ? | ? | ? | ||
| Cost of raw materials per pound | ? | ? | ? | ? | ? | ||
| Cost of raw materials to be purchased | ? | ? | ? | ? | ? | ||
| Construct the schedule of expected cash payments | Year 2 Quarter | ||||||
| 1 | 2 | 3 | 4 | Year | |||
| Accounts payable, beginning balance | ? | ? | |||||
| First-quarter purchases | ? | ? | ? | ||||
| Second-quarter purchases | ? | ? | ? | ||||
| Third-quarter purchases | ? | ? | ? | ||||
| Fourth-quarter purchases | ? | ? | |||||
| Total cash disbursements | ? | ? | ? | ? | ? | ||
|
Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them. |
|||||||
| plz show the fomula for caculation | |||||||
In: Accounting
A corporate treasurer sells $10 non-callable 5-year bonds. He sees an attractive 5-year Libor floater at L+25. The 5-year swap curve is TSY 5-year plus 20 bps. The treasurer executes an interest rate swap. What does he do? What is his position after the swap?
What is the 'asset' that the manager ends up with?
In: Finance