\nBudget \tgeneral
\n15 questions answered for a statistics class. The first additional file is to answer questions 1&3 for Part 1 and the second additional file is to answer all of Part 2 questions. I need the answers only.<\/p>\n
PART 1
\n1. The attached Spreadsheet ?SleepScores? contains data on the number of hours of sleep the night before an exam (X) and the number of multiple choice questions answered correctly on the exam (Y) from a sample of undergraduate students.
\nCalculate the regression line for these data.
\nGive the slope to at least 2 places past the decimal point.<\/p>\n
\n2. The regression equation for the data in the last question is Y? = 2.28(X) + 1.427. What is the predicted number of questions correct for someone who only got 4 hours of sleep?
\nGive at least 2 places past the decimal point<\/p>\n
3. Calculate a t statistic for testing the significance of the slope in the ?SleepScores? data where the regression line is Y? = 2.28(X) + 1.427
\nReport a numeric value to at least 2 decimal places.<\/p>\n
4. Calculate a 2-tailed p value for the t statistic you found in the previous question for testing the significance of the slope in the ?SleepScores? data where the regression line is Y? = 2.28(X) + 1.427.
\nReport a numeric value to at least 2 decimal places.<\/p>\n
5. Which of the following are required assumptions for calculating inferential statistics of a regression? (Select all that apply)
\n\t\tHomoscedasticity: The variance around the regression line is the same for all values of X
\n\t\tHeteroscedasticity: The variance around the regression line must increase as X increases.
\n\t\tLinearity: The relationship between the two variables is linear.
\n\t\tThe errors of prediction are distributed normally.
\n\t\tAll the points must be on the regression line.
\n\t\tHomogeneity of variances: the variance of X and Y must be the same.<\/p>\n
\n6. Which of the following assumptions is required to conduct an ANOVA test? (Select all that apply)
\n\t\tThe populations have the same variance for the variable of interest
\n\t\tThe populations have different variances for the variable of interest
\n\t\tThe populations are normally distributed for the variable of interest
\n\t\tThe populations have the same mean for the variable of interest
\n\t\tEach value is sampled independently from each other value for the variable of interest
\nIf the null hypothesis is true, F is theoretically expected to be equal to what value?
\n(Give a numeric answer. Do not include any letters or symbols)<\/p>\n
7. Imagine an experiment having three conditions and 20 subjects within each condition. The mean and variances of each condition are listed below. What?s the value of mean squares between groups (MSB)?
\nCondition\tMean\tVariance
\nCondition 1\t3.2\t14.3
\nCondition 2\t4.2\t17.2
\nCondition 3\t7.6\t16.7
\n (Remember this number, you’ll need it again)
\n(Give a numeric answer to at least 1 decimal place. Do not include any letters or labels)<\/p>\n
8. Imagine an experiment having three conditions and 20 subjects within each condition. The mean and variances of each condition are listed below. What?s the value of mean square error (MSE)?
\nCondition\tMean\tVariance
\nCondition 1\t3.2\t14.3
\nCondition 2\t4.2\t17.2
\nCondition 3\t7.6\t16.7<\/p>\n
(Remember this number, you’ll need it again)
\n(Give a numeric answer to at least 3 decimal places. Do not include any letters or labels)<\/p>\n
\n9. Imagine an experiment having three conditions and 20 subjects within each condition. The mean and variances of each condition are listed below. What?s the value of F? (Same data as last 2 questions)
\nCondition\tMean\tVariance
\nCondition 1\t3.2\t14.3
\nCondition 2\t4.2\t17.2
\nCondition 3\t7.6\t16.7<\/p>\n
\n (Remember this number, you’ll need it again)<\/p>\n
(Give a numeric answer to at least 3 decimal places. Do not include any letters or labels)<\/p>\n
\n10. Imagine an experiment having three conditions and 20 subjects within each condition. The mean and variances of each condition are listed below. What?s the probability value of this result? (Same data as last 3 questions)
\nCondition\tMean\tVariance
\nCondition 1\t3.2\t14.3
\nCondition 2\t4.2\t17.2
\nCondition 3\t7.6\t16.7<\/p>\n
(Give a numeric answer to at least 4 decimal places. Do not include any letters or labels)<\/p>\n
PART 2<\/p>\n
An instructor asked his students to record the number of hours they studied for a particular exam. He then plotted hours of study against the students? exam grades in a scatter plot. Next he computed the correlation between the two variables and found the best-fitting regression line. The attached spreadsheet (in Question 1) shows the results.<\/p>\n
\n1. On average, how many hours did the students study for the exam? What was the average exam grade?<\/p>\n
2.What was the correlation between hours of studying and exam grade? What proportion of variance in exam grades could be accounted for by knowing hours of study?<\/p>\n
3. What is the equation for the best fitting regression line for predicting exam grades from hours of studying?<\/p>\n
4.Using the regression equation, what is the predicted exam score for someone who studied 6 hours for the exam? <\/p>\n
\n5. One of the nice features of a spreadsheet is that you can change the data and see how the graph and statistics change in real time. Go to the exam grade column and begin changing each grade so that its plotted point moves closer to the regression line. What happens to the correlation? What happens to r2?<\/p>\n
1.<\/p>\n
\nCorporate Finance<\/p>\n
1. Sailboats Etc. is a retail company specializing in sailboats and other sailing-related equipment. The table shown here,
\n ,
\ncontains financial forecasts as well as current (month 0) working capital levels. During which month is the firm’s change in net working capital thegreatest? When does it have surplus cash?
\nWe calculate the changes in net working capital for the firm: (Round to two decimal places.)
\n(000)\t \t1
\nChange in accounts receivable\t$\t
\nChange in inventory\t$\t
\nChange in accounts payable\t$\t
\nChange in net working capital\t$\t
\n \t2
\n$\t
\n$\t
\n$\t
\n$\t
\n \t3
\n$\t
\n$\t
\n$\t
\n$\t
\n \t4
\n$\t
\n$\t
\n$\t
\n$\t
\n \t5
\n$\t
\n$\t
\n$\t
\n$\t
\n \t6
\n$\t
\n$\t
\n$\t
\n$\t
\nDuring which month is the firm’s change in net working capital the greatest? (Select from the drop-down menu.)
\nFrom the table it can be seen that Sailboat’s change in net working capital is the highest in Month
\n?<\/p>\n
5
\n3
\n2
\n5<\/p>\n
because its investments in accounts receivable, inventory and accounts payable increased the most in that month.
\nTo determine when Sailboats has surplus cash, we calculate the changes in cash: (Round to two decimal places.)
\n(000)\t \t1
\nNet income\t$\t
\n+ Depreciation\t$\t
\n– Change in net working capital\t$\t
\nCash flow from operations\t$\t
\n– Capital expenditures\t$\t
\nChange in cash\t$\t
\n \t2
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n \t3
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n \t4
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n \t5
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n \t6
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\n$\t
\nWhen does it have surplus cash? (Select the best choice below.)<\/p>\n
A.
\nSailboats, Etc. has a surplus cash position in every month.<\/p>\n
B.
\nSailboats, Etc. has a surplus cash position in every month except in Month 1.<\/p>\n
C.
\nSailboats, Etc. has a surplus cash position in every month except in Month 6.<\/p>\n
D.
\nSailboats, Etc. has a surplus cash position in every month except in Month 3.
\nEnter any number in the edit fields and then continue to the next question.<\/p>\n
\n2. Discuss the three different arrangements under which a firm may use inventory to secure a loan. (Select from the drop-down menus.)
\nThe three different methods under which inventory is used as collateral for a loan are floating liens, trust receipts, and warehouse arrangements.
\nWith a
\n?<\/p>\n
trust receipt arrangement
\nwarehouse arrangement
\nfloating lien<\/p>\n
(also called a “general lien” or a “blanket lien”), all of the borrower’s inventory serves as collateral for a loan. The value of the collateral declines as the firm sells its inventory. In times of financial distress, a firm may decide to sell its inventory without making payments on the loan and may not have enough money to replenish the inventory it has sold. The loan is then under-collateralized. This is the riskiest arrangement from the lender’s standpoint, and the loan will carry a higher interest rate than if one of the other two methods is used. Additionally, the lender will lend a much smaller percentage of the inventory value under this arrangement.
\nIn a
\n?<\/p>\n
trust receipt arrangement
\nwarehouse arrangement
\nfloating lien<\/p>\n
(or floor planning arrangement), specific inventory items are identified as collateral for the loan. As the specified inventory is sold, the firm uses the cash received to repay the loan. The lender will send someone to the borrower’s premises periodically to ensure that none of the specified inventory has been sold without a repayment made.
\nIn a
\n?<\/p>\n
trust receipt arrangement
\nwarehouse arrangement
\nfloating lien
\n,
\nthe inventory serving as collateral is stored in a warehouse. One type of warehouse is a public warehouse, which is a business that exists for the sole purpose of tracking the flow of the inventory. The inventory is delivered to the public warehouse by the borrowing firm, and the lender extends a loan based on the value of that inventory. When the borrowing firm needs the inventory to sell, it must return to the warehouse to retrieve it after receiving permission from the lender to do so. This arrangement is the least risky from the standpoint of the lender since it allows the lender to maintain the tightest control over the inventory, but it is only feasible for some types of inventory. This method would not be usable for inventory that is subject to spoilage or that is bulky and difficult to transport. In this latter case, a field warehouse might be a good alternative. A field warehouse is established on the borrower’s premises, but it is separated from the borrower’s main plant. It is operated by a third party. This type of arrangement is more convenient for the borrower, but it still gives the lender the added security of having the inventory that serves as collateral tracked by a third party.<\/p>\n
3. Quarterly working capital levels for your firm for the next year are included in the following table. What are the permanent working capital needs of your company? What are the temporary needs?
\n\tQuarter
\n(000)
\n1\t2\t3\t4
\nCash\t$100100
\n$100100
\n$100100
\n$100100Accounts Receivable\t200200\t100100\t100100\t600600
\nInventory\t200200\t500500\t900900\t5050
\nAccounts Payable\t100100\t100100\t100100\t100100
\nWhat are the permanent working capital needs of your company?
\nThe permanent working capital needs of your company are
\n$ nothing.
\n(Round to nearest dollar.)
\nWhat are the temporary needs?
\nThe temporary needs for the first quarter are
\n$ nothing.
\n(Round to nearest dollar.)
\nThe temporary needs for the second quarter are
\n$ nothing.
\n (Round to nearest dollar.)
\nThe temporary needs for the third quarter are
\n$ nothing.
\n (Round to nearest dollar.)
\nThe temporary needs for the fourth quarter are
\n$ nothing.
\n(Round to nearest dollar.)
\nEnter your answer in each of the answer boxes.<\/p>\n
\n4. What is the difference between direct paper and dealer paper? (Select all of the choices below that apply.)<\/p>\n
A.
\nDirect paper is a method by which a firm sells its commercial paper directly to investors.<\/p>\n
B.
\nDealer paper refers to the sale of commercial paper through dealers. <\/p>\n
C.
\nThe dealers get a fee for their services, thus reducing the proceeds that the issuing firm receives (and increasing the effective cost to the firm).<\/p>\n
D.
\nDirect paper allows a firm to save issuing costs by selling its commercial paper directly to dealers.<\/p>\n
E.
\nDealer paper is named as such when a firm is acting as the dealer by issuing commercial paper directly to investors.
\nClick to select your answer(s).<\/p>\n
5. Ohio Valley Homecare Suppliers, Incorporated (OVHS) had
\n$ 17$17
\nmillion in sales in 2009. Its cost of goods sold was
\n$ 6.8$6.8
\nmillion, and its average inventory balance was
\n$ 2.1$2.1
\nmillion.
\na. Calculate the number of inventory days outstanding for OVHS.
\nb. The average number of inventory days in the industry is
\n7373
\ndays. By how much would OVHS reduce its investment in inventory if it could improve its inventory days to meet the industry average?
\na. Calculate the number of inventory days outstanding for OVHS.
\nThe number of inventory days is
\n nothing
\ndays. (Round to the nearest integer.)
\nb. The average number of inventory days in the industry is
\n7373
\ndays. By how much would OVHS reduce its investment in inventory if it could improve its inventory days to meet the industry average?
\nOVHS would reduce its inventory by
\n$ nothing.
\n(Round to the nearest dollar.)
\nEnter your answer in each of the answer boxes.<\/p>\n
\n6. Which of the following one-year
\n$ 1 comma 000$1,000
\nbank loans offers the lowest effective annual rate?
\na. A loan with an APR of
\n5.7 %5.7%,
\ncompounded monthly.
\nb. A loan with an APR of
\n5.7 %5.7%,
\ncompounded annually, that also has a compensating balance requirement of
\n10.5 %10.5%
\n(on which no interest is paid).
\nc. A loan with an APR of
\n5.7 %5.7%,
\ncompounded annually, that has a
\n1.3 %1.3%
\nloan origination fee.
\na. A loan with an APR of
\n5.7 %5.7%,
\ncompounded monthly. (Select from the drop-down menus.)
\nSince the APR is
\n5.7 %5.7%,
\nthe monthly rate is
\n?<\/p>\n
0.275%
\n0.475%
\n0.575%
\n.
\nThis translates to an effective annual rate of
\n?<\/p>\n
5.7%
\n5.9%
\n6%
\n.
\nb. A loan with an APR of
\n5.7 %5.7%,
\ncompounded annually, that also has a compensating balance requirement of
\n10.5 %10.5%
\n(on which no interest is paid). (Select from the drop-down menus.)
\nThe compensating balance is
\n?<\/p>\n
$85
\n$115
\n$105
\n.
\nTherefore, the borrower will have use of only
\n?<\/p>\n
$895
\n$885
\n$915<\/p>\n
of the
\n$ 1 comma 000$1,000.
\nThe interest is
\n?<\/p>\n
$53
\n$57
\n$59
\n.
\nThe interest rate per period is
\n?<\/p>\n
6.2%
\n6.4%
\n6.5%
\n.
\nSince this alternative assumes annual compounding, the effective annual rate is
\n?<\/p>\n
6.5%
\n6.2%
\n6.4%<\/p>\n
as well.
\nc. A loan with an APR of
\n5.7 %5.7%,
\ncompounded annually, that has a
\n1.3 %1.3%
\nloan origination fee. (Select from the drop-down menus.)
\nThe interest expense is
\n?<\/p>\n
$59
\n$53
\n$57
\n,
\nand the loan origination fee is
\n?<\/p>\n
$13
\n$14
\n$11
\n.
\nThe loan origination fee reduces the usable proceeds of the loan to
\n?<\/p>\n
$987
\n$989
\n$986<\/p>\n
because it is paid at the beginning of the loan. The interest rate per period is
\n?<\/p>\n
7.1%
\n6.9%
\n7.2%
\n.
\nSince the loan is compounded annually in this case,
\n?<\/p>\n
7.2%
\n7.1%
\n6.9%<\/p>\n
is the effective annual rate.
\n(Select from the drop-down menu.)
\nThus, alternative
\n?<\/p>\n
(c)
\n(b)
\n(a)<\/p>\n
offers the lowest effective annual cost.<\/p>\n
7. Etemadi Amalgamated, a U.S. manufacturing firm, is considering a new project in the euro area. You are in Etemadi’s corporate finance department and are responsible for deciding whether to undertake the project. The free cash flows, in euros, are forecast to be thefollowing:
\nYear\tFree Cash Flow (millions of
\neuro?)0\tnegative 15-15
\n1\t99
\n2\t1010
\n3\t1111
\n4\t1212
\nYou know that the spot exchange rate is
\nUpper S equals $ 1.1500 divided by euroS=$1.1500\/?.
\nIn addition, the risk-free interest rate on dollars is
\n4.0 %4.0%,
\nand the risk-free interest rate on euros is
\n6.0 %6.0%
\n(and the yield curve is flat in both currencies).
\nAssume that these markets are internationally integrated and the uncertainty in the FCFs is not correlated with uncertainty in the exchange rate. You determine that the dollar WACC for these cash flows is
\n8.5 %8.5%.
\na. What is the dollar present value of the project? Should Etemadi Amalgamated undertake the project?
\nb. Assume that the spot rate is now
\n8. Upper S equals $ 0.8500 divided by euroS=$0.8500\/?,
\nabout
\n26 %26%
\nlower. What is the new present value of the project in dollars? What is the new present value of the project in dollars? Should Etemadi Amalgamated undertake the project?
\nHint: Make sure to round all intermediate calculations to at least four decimal places.
\na. What is the dollar present value of the project?
\nFirst, calculate the forward rates.
\nThe forward exchange rates for year 1 is
\n$ nothing\/euro?.
\n(Round to four decimal places.)
\nThe forward exchange rates for year 2 is
\n$ nothing\/euro?.
\n (Round to four decimal places.)
\nThe forward exchange rates for year 3 is
\n$ nothing\/euro?.
\n (Round to four decimal places.)
\nThe forward exchange rates for year 4 is
\n$ nothing\/euro?.
\n(Round to four decimal places.)
\nNext, you need to find the expected cash flow of the project.
\nThe expected dollar cash flow of for year 0 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 1 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 2 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 3 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 4 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nFinally, calculate the net present value.
\nThe dollar present value of the project is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nShould Etemadi Amalgamated undertake the project?
\n?<\/p>\n
Yes
\nNo
\n.
\n(Select from the drop-down menu.)
\nb. Assume that the spot rate is now
\nUpper S equals $ 0.8500 divided by euroS=$0.8500\/?,
\nabout
\n26 %26%
\nlower. What is the new present value of the project in dollars?
\nFirst, calculate the forward rates.
\nThe forward exchange rates for year 1 is
\n$ nothing\/euro?.
\n(Round to four decimal places.)
\nThe forward exchange rates for year 2 is
\n$ nothing\/euro?.
\n(Round to four decimal places.)
\nThe forward exchange rates for year 3 is
\n$ nothing\/euro?.
\n(Round to four decimal places.)
\nThe forward exchange rates for year 4 is
\n$ nothing\/euro?.
\n(Round to four decimal places.)
\nNext, you need to find the expected cash flow of the project.
\nThe expected dollar cash flow of for year 0 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 1 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 2 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 3 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nThe expected dollar cash flow of for year 4 is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nFinally, calculate the net present value.
\nThe dollar present value of the project is
\n$ nothing
\nmillion. (Round to four decimal places.)
\nShould Etemadi Amalgamated undertake the project? (Select from the drop-down menus.)
\nEtemadi Amalgamated should
\n?<\/p>\n
still
\nnot<\/p>\n
undertake the project because the net present value is
\n?<\/p>\n
positive
\nnegative
\n.
\nEnter your answer in each of the answer boxes.<\/p>\n
\n9. What are the three steps involved in establishing a credit policy? (Select all of the choices below that apply.)
\nThe three steps involved in establishing a credit policy are:<\/p>\n
A.
\nEstablish credit standards. In this step, the firm must decide how much credit risk it is willing to accept.<\/p>\n
B.
\nEstablish credit terms. Here, the firm decides on the length of time before payment must be made and whether or not it will offer a discount. If a discount is to be offered, the amount of the discount and the length of the discount period must also be established.<\/p>\n
C.
\nEstablish a collection policy. In this step, the firm must decide how it will collect from all of its credit customers.<\/p>\n
D.
\nEstablish a collection policy. In this step, the firm must decide how it will handle late payers.
\nClick to select your answer(s).<\/p>\n
10. Aberdeen Outboard Motors is contemplating building a new plant. The company anticipates that the plant will require an initial investment of
\n$ 1.97$1.97
\nmillion in net working capital today. The plant will last
\n88
\nyears, at which point the full investment in net working capital will be recovered. Given an annual discount rate of
\n5.8 %5.8%,
\nwhat is the net present value of this working capital investment?
\nThe NPV is
\n$ nothing.
\n(Round to the nearest dollar.)<\/p>\n
11. Simple Simon’s Bakery purchases supplies on terms of
\n1.0 divided by 10 comma net 251.0\/10, net 25.
\nIf Simple Simon’s chooses to take the discount offered, it must obtain a bank loan to meet its short-term financing needs. A local bank has quoted Simple Simon’s owner an interest rate of
\n12.0 %12.0%
\non borrowed funds. Should Simple Simon’s enter the loan agreement with the bank and begin taking the discount? (Use 365 days for a year.)
\nSimple Simon’s can earn an effective rate of
\n nothing%.
\n(Round to one decimal place.)
\nShould Simple Simon’s enter the loan agreement with the bank and begin taking the discount? (Select the best choice below.)<\/p>\n
A.
\nSimple Simon’s will earn
\n27.7 %27.7%
\non its purchases by paying within the discount period and should enter into the loan agreement.<\/p>\n
B.
\nSimple Simon’s will earn
\n15.8 %15.8%
\non its purchases by paying within the discount period and should enter into the loan agreement. <\/p>\n
C.
\nThe discount rate of
\n1.0 %1.0%
\nis considerably lower than the
\n12.0 %12.0%
\ninterest rate, so Simple Simon’s should not enter into the loan agreement.<\/p>\n
D.
\nNeed more information to answer the question.<\/p>\n
Your supplier offers terms of
\n1.41.4\/1010,
\nNet
\n4545.
\nWhat is the effective annual cost of trade credit if you choose to forgo the discount and pay on day
\n4545?
\nThe effective annual cost of the trade credit is
\n nothing%.
\n(Round to two decimal places.)<\/p>\n","protected":false},"excerpt":{"rendered":"
Budget general 15 questions answered for a statistics class. The first additional file is to answer questions 1&3 for Part 1 and the second additional file is to answer all of Part 2 questions. I need the answers only. PART Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-7839","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/7839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=7839"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/7839\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=7839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=7839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=7839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}