|
I need the formulas in excel: Thank you You're talking to a friend of yours who has student loans of $30,000. She has just graduated and now needs to pay them back with monthy payments at a 4.19% interest rate over the next 10 years. |
|||||||||
| a. Create a loan amortization table for this loan. | |||||||||
| b. If she increases her monthly payment by $100, how much sooner will she have paid off the loan? | |||||||||
| loan balance | |||||||||
| number of payments | |||||||||
| interest rate | |||||||||
| monthly payments | |||||||||
| Part a. | Part b. | ||||||||
| Month | Amount owed at beginning | Payment | Amount to Interest | Amount to principle | Amount owed at end | How much sooner will she pay off the loan? | |||
| 1 | |||||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 | |||||||||
| 8 | |||||||||
| 9 | |||||||||
| 10 | |||||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 | |||||||||
| 25 | |||||||||
| 26 | |||||||||
| 27 | |||||||||
| 28 | |||||||||
| 29 | |||||||||
| 30 | |||||||||
| 31 | |||||||||
| 32 | |||||||||
| 33 | |||||||||
| 34 | |||||||||
| 35 | |||||||||
| 36 | |||||||||
| 37 | |||||||||
| 38 | |||||||||
| 39 | |||||||||
| 40 | |||||||||
| 41 | |||||||||
| 42 | |||||||||
| 43 | |||||||||
| 44 | |||||||||
| 45 | |||||||||
| 46 | |||||||||
| 47 | |||||||||
| 48 | |||||||||
| 49 | |||||||||
| 50 | |||||||||
| 51 | |||||||||
| 52 | |||||||||
| 53 | |||||||||
| 54 | |||||||||
| 55 | |||||||||
| 56 | |||||||||
| 57 | |||||||||
| 58 | |||||||||
| 59 | |||||||||
| 60 | |||||||||
| 61 | |||||||||
| 62 | |||||||||
| 63 | |||||||||
| 64 | |||||||||
| 65 | |||||||||
| 66 | |||||||||
| 67 | |||||||||
| 68 | |||||||||
| 69 | |||||||||
| 70 | |||||||||
| 71 | |||||||||
| 72 | |||||||||
| 73 | |||||||||
| 74 | |||||||||
| 75 | |||||||||
| 76 | |||||||||
| 77 | |||||||||
| 78 | |||||||||
| 79 | |||||||||
| 80 | |||||||||
| 81 | |||||||||
| 82 | |||||||||
| 83 | |||||||||
| 84 | |||||||||
| 85 | |||||||||
| 86 | |||||||||
| 87 | |||||||||
| 88 | |||||||||
| 89 | |||||||||
| 90 | |||||||||
| 91 | |||||||||
| 92 | |||||||||
| 93 | |||||||||
| 94 | |||||||||
| 95 | |||||||||
| 96 | |||||||||
| 97 | |||||||||
| 98 | |||||||||
| 99 | |||||||||
| 100 | |||||||||
| 101 | |||||||||
| 102 | |||||||||
| 103 | |||||||||
| 104 | |||||||||
| 105 | |||||||||
| 106 | |||||||||
| 107 | |||||||||
| 108 | |||||||||
| 109 | |||||||||
| 110 | |||||||||
| 111 | |||||||||
| 112 | |||||||||
| 113 | |||||||||
| 114 | |||||||||
| 115 | |||||||||
| 116 | |||||||||
| 117 | |||||||||
| 118 | |||||||||
| 119 | |||||||||
| 120 | |||||||||
In: Finance
It is known that the mean time to solve the puzzle in healthy control children is 60 seconds. Carry out the Wilcoxon signed-rank test on these data to test the null hypothesis that the mean time to solve the puzzle for children with NF1 is the same as for healthy controls.
a) Calculate the value of the test statistic and give the approximate normal distribution of the test statistic under the null hypothesis.
b) Calculate the p-value for the test assuming a two-sided alternative hypothesis.
c) What do you conclude about the time taken by children with NF1 to solve the puzzle compared to healthy controls?
d) Describe in a few sentences how you would calculate a 95% confidence interval for the mean time without assuming any particular parametric model for the data. You do not need to calculate the interval.
Provided data is:-
ID yi
1 51
2 60
3 75
4 43
5 92
6 72
7 49
8 39
9 62
10 127
11 51
12 75
13 69
14 59
15 25
16 58
17 95
18 63
19 91
20 63
21 32
22 50
23 108
24 41
25 93
26 43
27 74
28 50
29 55
30 60
31 62
32 91
33 79
34 71
35 85
36 86
37 78
38 100
39 146
40 62
41 134
42 41
43 40
44 51
45 68
46 59
47 59
48 38
49 66
50 79
51 111
52 69
53 68
54 110
55 69
56 62
57 91
In: Statistics and Probability
PART 1
You are studying the following regression on earnings of a CEO:
Earnings)= 3.86 - 0.28Female + 0.37MarketValue + 0.004Return
You wonder whether any of the independant variables should be introduced in the model in a nonlinear fashion instead. Right now, they are all present in their original form. Which variables must you test to see if a nonlinear version of them is better suited?
A. Earnings, Female, MarketValue, Returns
B. Earnings, MarketValue, Returns
C. Female, MarketValue, Return
D. MarketValue, Returns
PART 2
"A standard ""money demand"" function used by macroeconomists has the form ln(m) = Beta0 + Beta1 ln(GDP) + Beta2 R, Where m is the quantity of (real) money, GDP is the value of (real) gross domestic product, and R is the value of the nominal interest rate measured in percent per year. Supposed that Beta 1 = 1.05 and Beta 2 = -0.03. What is the expected change in m if the interest rate increases from 5% to 9%? Round to nearest integer"
A. decrease 12%
B. decrease 9%
C. increase 12%
D. "decrease $7,387"
PART 3
"This problem is inspired by a study of the ""gender gap"" in earnings in top corporate jobs [Bertrand and Hallock (2001)]. The study compares total compensation among top executives in a large set of U.S. public corporations in the 1990s. (Each year these publicly traded corporations must report total compensation levels for their top five executives.) Let Female be an indicator variable that is equal to 1 for females and 0 for males. A regression of the logarithm of earnings onto Female yields ln(Earnings) = 6.55 -0.41Female, SER = 2.44. The Standard Errors for the Constant is (0.01) and for the Female variable is (0.05). The SER tells us all of the following, except:"
A. The Standard Error of the regression
B. The % of the variance in Earnings we have explained
C. The standard deviation of the regression error
D. The square root of the variance of the residuals
PART 4
"Assume that you had estimated the following quadratic regression model: Test Score = 607.3 + 3.85Income - 0.0423Income2. If income is in thousands, please interpret the coefficient on the Income2 term:"
A. Cannot interpret that coefficient alone
B. A 1 unit increase in income is associated with a 0.0423 points
decrease in TestScores
C. "A $1,000 increase in income is associated with a 0.0423 points
decrease in TestScores"
D. "A $1,000 increase in income is associated with a 4.23 %
decrease in TestScores"
In: Economics
Mary, the plant manager of Southern Oregon Injection Molding, Inc. (SOIM), is pondering an interesting offer made by the president and majority shareholder, Kenny. Kenny recently turned sixty and is planning a gradual retirement. None of his children are interested in taking over the business and are currently pursuing careers unrelated to the plastics industry, so Kenny has decided to offer his controlling share to Mary.
SOIM began by manufacturing plastic lawn ornaments, including a colorful tropical bird that became a major fad in the 1980s. Pleased and amused by the success of his fanciful product, Kenny added rabbits, skunks, trolls, angels, and garden fairies to the product line. Under Mary’s leadership, SOIM has also become an important secondary supplier of plastic housings for speakers, cell phones, calculators, and similar products.
Marry started working at SOIM as a color technician shortly after graduating from Southern Oregon University with a degree in chemical engineering. Within five years, she became the plant manager, a position she has held for the last eight years. Along the way, she has earned an MBA through the evening program at Southern Oregon University.
Because SOIM stock is publicly traded, we can confidently assign a value of $10,000,000 to Kenny’s shares. Kenny has stated that he is open to any reasonable plan to finance the purchase.
Questions
1. Mary could probably borrow the money to purchase the shares outright because the shares would serve as collateral and dividends would cover a good part of the loan payments. The interest rate is 7%, and the lender will amortize the loan with a series of equal payments. What are the annual payments if the bank amortizes the loan over five, ten, or twenty years?
2. Repeat Question 1, but assume that Mary makes payments at the beginning of each year.
3. Complete the following amortization schedule for a $10,000,000 loan at 7% with five equal end-ofyear payments.
4. Kenny has offered to finance the purchase with a ten-year, interest-only loan. How much is Mary’s annual payment? Describe the pattern of payments over the ten years.
5. Assume that Kenny accepts Mary’s offer to finance the purchase with a ten-year, interest-only loan. If Kenny can reinvest the interest payments at a rate of 7% per year, how much money will he have at the end of the tenth year?
In: Finance
The State of DeNile built a new toll road 3 years ago for $900 million. The state can charge tolls on the road for the next 20 years and expects to spend $3 million per year on maintenance and toll collection. Toll revenue is expected to be $80 million per year. The state has recently received an offer from the Otto Corporation to lease the road for 20 years. The company will pay DeNile $1 billion and will receive exclusive rights to collect and keep the tolls. Otto Corp will also be responsible for all maintenance and other expenses. The state can invest its money at 6% annual return. Should the state take this offer? Why or why not?
In: Finance
Please Provide the Answers and Solution for this Question Clearly:
. Presented below is information related to Dublin Company for 2018.
|
Unrealized gain on non-trading equity securities, net of tax |
€200,000 |
|
Retained earnings balance, January 1, 2018 |
1,200,000 |
|
Sales revenue |
35,000,000 |
|
Unearned sales revenue |
150,000 |
|
Prepaid expense |
80,000 |
|
Freight-In |
10,000 |
|
Cost of goods sold |
25,000,000 |
|
Purchase Discounts |
15,000 |
|
Interest expense |
100,000 |
|
Selling and administrative expenses |
5,700,000 |
|
Write-off of goodwill |
1,200,000 |
|
Income taxes for 2018 |
1,360,000 |
|
Dividend revenue |
100,000 |
|
Gain on the disposition and operations of the wholesale division (Gain before income tax) |
400,000 |
|
Loss due to flood damage |
300,000 |
|
Gain on the sale of investments |
200,000 |
|
Dividends declared on ordinary shares |
250,000 |
|
Allocation to non-controlling interest |
30,000 |
Required:
Prepare an (1) income statement and (2) a retained earnings statement. Dublin Company decided to discontinue its entire wholesale operations and to retain its manufacturing operations. On August 10, Dublin sold the wholesale operations to Rene Company. During 2018, there were 400,000 ordinary shares outstanding all year.
In: Accounting
B. Presented below is information related to Dublin Company for 2018.
|
Unrealized gain on non-trading equity securities, net of tax |
€200,000 |
|
Retained earnings balance, January 1, 2018 |
1,200,000 |
|
Sales revenue |
35,000,000 |
|
Unearned sales revenue |
150,000 |
|
Prepaid expense |
80,000 |
|
Freight-In |
10,000 |
|
Cost of goods sold |
25,000,000 |
|
Purchase Discounts |
15,000 |
|
Interest expense |
100,000 |
|
Selling and administrative expenses |
5,700,000 |
|
Write-off of goodwill |
1,200,000 |
|
Income taxes for 2018 |
1,360,000 |
|
Dividend revenue |
100,000 |
|
Gain on the disposition and operations of the wholesale division (Gain before income tax) |
400,000 |
|
Loss due to flood damage |
300,000 |
|
Gain on the sale of investments |
200,000 |
|
Dividends declared on ordinary shares |
250,000 |
|
Allocation to non-controlling interest |
30,000 |
Required:
Prepare an (1) income statement and (2) a retained earnings statement. Dublin Company decided to discontinue its entire wholesale operations and to retain its manufacturing operations. On August 10, Dublin sold the wholesale operations to Rene Company. During 2018, there were 400,000 ordinary shares outstanding all year.
In: Accounting
E4-23
Prepare closing entries.
The adjusted trial balance for Ryan Company is given below.
Instructions
Prepare the closing entries for the temporary accounts at August 31.
The trial balances shown below are before and after adjustment for Ryan Company at the end of its fiscal year.
|
RYAN COMPANY Trial Balance August 31, 2017 |
||||
|---|---|---|---|---|
|
Before Adjustment |
After Adjustment |
|||
|
Dr. |
Cr. |
Dr. |
Cr. |
|
|
Cash |
$10,900 |
$10,900 |
||
|
Accounts Receivable |
8,800 |
9,400 |
||
|
Supplies |
2,500 |
500 |
||
|
Prepaid Insurance |
4,000 |
2,500 |
||
|
Equipment |
16,000 |
16,000 |
||
|
Accumulated Depreciation—Equipment |
$ 3,600 |
$ 4,800 |
||
|
Accounts Payable |
5,800 |
5,800 |
||
|
Salaries and Wages Payable |
0 |
1,100 |
||
|
Unearned Rent Revenue |
1,800 |
800 |
||
|
Common Stock |
10,000 |
10,000 |
||
|
Retained Earnings |
5,500 |
5,500 |
||
|
Dividends |
2,800 |
2,800 |
||
|
Service Revenue |
34,000 |
34,600 |
||
|
Rent Revenue |
12,100 |
13,100 |
||
|
Salaries and Wages Expense |
17,000 |
18,100 |
||
|
Supplies Expense |
0 |
2,000 |
||
|
Rent Expense |
10,800 |
10,800 |
||
|
Insurance Expense |
0 |
1,500 |
||
|
Depreciation Expense |
0 |
1,200 |
||
|
$72,800 |
$72,800 |
$75,700 |
$75,700 |
|
In: Accounting
As a reviewer for the Ontario Securities Commission, you are in the process of reviewing the financial statements of public companies. The following items have come to your attention: 1. A merchandising company overstated its ending inventory two years ago by a material amount. Inventory for all other periods is correctly calculated. 2. An automobile dealer sells for $137,000 an extremely rare 1930 S-type Invicta, which it purchased for $21,000 10 years ago. The Invicta is the only such display item that the dealer owns. 3. During the current year, a drilling company extended the estimated useful life of certain drilling equipment from 9 to 15 years. As a result, amortization for the current year was materially lowered. 4. A retail outlet changed its calculation for bad debt expense from 1% to 0.5% of sales because of changes in its clientele. 5. A mining company sells a large foreign subsidiary that does uranium mining, although the company continues to mine uranium in other countries. 6. A steel company changes from straight-line depreciation to accelerated amortization in accounting for its plant assets, stating that the expected pattern of consumption of the future economic benefits has changed. 7. A construction company, at great expense to itself, prepares a major proposal for a government loan. The loan is not approved. 8. A water pump manufacturer has had large losses resulting from a strike by its employees early in the year. 9. Amortization for a prior period was incorrectly understated by $950,000. The error was discovered in the current year. 10. A large sheep rancher suffered a major loss because the provincial government required that all sheep in the province be killed to halt the spread of a rare dis- ease. Such a situation has not occurred in the province for 20 years. 11. A food distributor that sells wholesale to supermarket chains and to fast-food restaurants (two major classes of customers) decides to discontinue the division that sells to one of the two classes of customers. Instructions Discuss the financial reporting issues.
In: Accounting
What is the standard deviation of students math test scores? 12 18 27 31 40 42 14 20 27 32 40 51 14 20 27 32 40 56 14 21 29 32 40 60 16 23 31 36 40 65
In: Psychology