by | Aug 1, 2022 | Mathematics
Purpose This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models. Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_File Instructions: The Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database: FloorArea: square feet of floor space Offices: number of offices in the building Entrances: number of customer entrances Age: age of the building (years) AssessedValue: tax assessment value (thousands of dollars) Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics. Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables? Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue? Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables? Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue? Construct a multiple regression model. Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2? Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated? What is the final model if we only use FloorArea and Offices as predictors? Suppose our final model is: AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices What wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?
by | Jul 31, 2022 | Mathematics
This is a midterm that starts at 1 pm on Monday and have 2 hours to complete. I will send a word document of the test at the time. Its on finite mathematics, including matrices, linear programming, game theory. I get the test at 1 so I’ll send it then and then there are 2 hours to complete. 15 questions and work has to be shown.
by | Jul 31, 2022 | Mathematics
Module 11 Textbook Exercises Goodness of Fit Test: 18-24, 26, 27, 31, 32 Test of Independence: 43-51, 66, 71 Test for Homogeneity: 84-88, 89 Example video below– https://www.screencast.com/t/1FaomYszQ Use the link below to answer assignment questions– https://courses.lumenlearning.com/introstats1/chapter/section-exercises-4/ Module 11 needs to be completed. I will leave an additional document attached to refer to for exmples labeled module 11 example
by | Jul 30, 2022 | Mathematics
Test 2
1. Sustainable Growth Rate (Part A through D)
2. Weighted Average Cost of Capital (WACC)
3. External Financing Needed (EFN) – AutoCalc – percentage of sales method
4. External Financing Needed (EFN) – Direct Method (Part A and B)
5. External Financing Needed (EFN) – Excess Capacity (90%)
Test 2
o Submit on Canvas by 10:30 am, Tuesday, November 23, 2021.
o There is a penalty of 1point for every 1 minute that the submission is late.
o You may not work with (get help from/give help to) anyone else on this test.
Use ONE Excel workbook, but a separate sheet for each problem. You may work all parts of the same problem in one sheet (e.g. parts A through D of Question 1), and so on. So, as there are 5 questions on the test, your Excel workbook should have 5 sheets.
Show work clearly, else NO partial credit will be given.
Question 1 (25 Points)
A. Use the information below from Paxton Industries annual financial statements to calculate the actual and sustainable growth rate for each year from 2016 – 2020. (15 points)
B. Describe the company’s growth challenge, if any, over this period. (5 points)
C. Comment on the observed change in the company’s payout policy over the period in question. Does it make sense in the context of the company’s growth challenge? Explain. (2.5 points)
D. What are some recommendations you might provide management that will help to meet this growth challenge? (2.5 points)
Paxton Industries ($ in thousands)
2014 2015 2016 2017 2018 2019 2020
Equity – 377.49 464.35 507.78 471.87 603.06 680.72
Total assets – 520.00 706.78 724.04 759.90 1071.07 1423.35
Sales 597.30 585.03 861.95 950.41 1139.48 1360.58 1721.78
Net income – 51.92 31.57 46.18 53.81 30.91 38.26
Dividends – 0.00 0.00 1.20 1.88 2.56 3.04
Question 2 (20 points)
Dexter Corp has 9.4% coupon bonds outstanding that have a remaining maturity of 10 years. They pay interest semiannually, and are currently selling for $1075 for every $1000 of face value. The firm also has perpetual preferred stock outstanding. Each of the preferred shares has a par value of $100, and is currently trading for $80. Each carries a fixed annual dividend of $10. Dexter common stock is trading at $38.40 per share. Each share of common is expected to pay a dividend of $4.15 for the coming year (i.e. one year from today). Analysts expect Dexter earnings and per-share dividends to grow at a constant rate of 3.75% for the foreseeable future. Dexter stock is estimated to have a beta of 1.55. The estimated market risk premium is 7%, and the proxy for the risk-free rate is the 3.25% yield on US Treasury securities. Dexter faces a marginal tax rate of 28%. Its management has a policy of raising funds in the following market-value based proportions: Common Stock 25%; Debt 60%; and Preferred Stock 15%. Estimate Dexter Corp’s weighted average cost of capital (WACC).
Use the financials for Garland Company below to answer Questions 3—5
Garland Company
Balance Sheet, Year Ended Dec 31, 2020
Assets:
Cash and marketable securities $ 500,000
Accounts receivable 800,000
Inventories 1,350,000
Prepaid expenses 50,000
Total current assets $ 2,700,000
Gross Fixed Assets 5,000,000
Accumulated Depreciation 2,000,000
Net fixed assets $ 3,000,000
Total assets $ 5,700,000
Liabilities:
Accounts payable $ 475,000
Notes payable 900,000
Total current liabilities $ 1,375,000
Long-term debt 1,200,000
Owner’s equity 3,125,000
Total liabilities and owner’s equity $ 5,700,000
Garland Company
Income Statement, 2020
Net sales $ 8,000,000
Cost of Goods Sold 3,500,000
Selling and administrative expense 2,000,000
Depreciation expense 250,000
Interest expense 150,000
Earnings before taxes $ 2,100,000
Income taxes 700,000
Net income $ 1,400,000
Question 3 (25 points)
On account of its very recent entry into a lucrative market, Garland Company (whose financials are given above) projects an 18% increase in sales for next year (2020). NOTE: All numbers in the financials are in thousands of dollars. The company paid out $1.26 billion in dividends in 2020, and its payout ratio is constant. Current assets and net fixed assets, and all operating expenses, vary directly with sales. Accounts payables will also maintain their existing relationship to sales; the other liabilities, however, are not spontaneous. Management has decided that any required additional funding will be raised through long-term debt, on which it will pay an interest rate of 8.5%. Any short-term debt will be rolled over at the same interest rate as existed at the end of 2020. Long-term debt will increase by the full amount of any estimated EFN (i.e., no principal pay-down on existing debt is anticipated for next year, 2021). NOTE: This means that none of the existing debt will be paid down in 2021, and will be charged the same interest rate as it was charged in 2020. The tax rate for 2020 will apply for 2021 as well. NOTE: You need to figure the tax rate yourself, based on the financials provided.
Estimate the external financing needed (EFN) for 2021, based on the projected growth in sales, using the percentage of sales method. Make sure to set up an “assumptions box”, and automate the iterations (like we did in class) needed to estimate EFN.
Question 4
Refer to the information provided for Garland in Question 3.
A. Use the “direct estimation of EFN” formula to estimate the external financing needed to support the projected growth in 2021. Do NOT use the pro-forma financials to estimate the EFN. Show work clearly, please. (10 points)
B. The EFN “direct” formula has 3 parts. Explain what each part estimates (here, I am looking for the “concept” behind each part, not the number). ALSO, what are the assumptions implicit in your calculation of Garland’s EFN using the direct formula? Kindly be brief. (5 points)
Question 5
Suppose Garland Company (whose financials were provided above and used in Questions 3 & 4) is actually operating at 90% capacity. Adjust your EFN estimate from Part A of the previous question (Question 4, Part A) with this information in mind. What is the new estimate of Garland’s EFN? Show all work clearly. (15 points)
by | Jul 30, 2022 | Mathematics
For the following exercises, use this scenario: A dart is thrown upward with an initial velocity of 65 ft per second at an angle of elevation of 52°. Consider the horizontal and vertical positions of the dart at any time t. Neglect air resistance.
Part I: Complete the following steps:
Find parametric equations that model the problem situation.
Use the GeoGebra tool to graph the parametric equations. (Refer to this tutorial as needed: https://www.geogebra.org/m/XUv5mXTm (Links to an external site.).)
Find all possible values for t that represent the situation.
State the parametric equations.
State the domain and range for each parametric equation.
Plot the minimum and maximum heights of the dart.
Plot the minimum and maximum horizontal positions of the dart.
Find the time at which the dart reaches the maximum height.
Save your GeoGebra work as a .pdf file for submission.
Part II: Based on your work in Part I, discuss the following:
Discuss why this situation can be modeled using parametric equations.
Discuss how you determined all possible values for t that represent the situation.
Discuss what the domain and range of the parametric equations mean in the context of this problem.
What do maximum and minimum values of the parametric equations represent in this context?
Discuss how your answers to Part I would be affected if:
The initial velocity is increased.
The angle of elevation is decreased.
Provide at least two other real-world situations that can be modeled using parametric functions and respond to the following:
What common characteristics do the real-world scenarios you chose share?
What did you look for in the way that the real-world scenario can be modeled?
How can you verify that the real-world scenarios you chose can be modeled by parametric functions?
Discussion may include: The horizontal and vertical positions of the dart as a function of time can serve as parametric equations to model this situation. In this case, t can be any non-negative real number. The domains of the parametric equations are any non-negative real number. The range of the vertical position function is, assuming the ground is at a height of 0, also any non-negative real number while the range of the horizontal position function is any real number assuming 0 is where the dart is first thrown. Any real-world scenario involving parametric equations should involve an independent parameter such as time and at least two variables that are a function of the independent parameter.
Requirements:
You must submit two files for this assignment. The first file should contain the computations, graphs, diagrams, etc., associated with the questions in Part I. This file may be formatted as a numbered list of answers. Unless stated in the problem, a narrative discussion is not required, but you must provide enough information to show how you arrived at the answer.
The second file should be a 2-3 page narrative paper, written in APA format, associated with the situation described in Part II. Specific requirements for the paper are provided below:
Your paper should be 2-3 pages in length (not counting the title page and references page) and cite and integrate at least two credible outside sources. The CSU-Global Library is a great place to find resources. Your textbook is a credible resource.
Include a title page, introduction, body, conclusion, and a reference page.
The introduction should describe or summarize the topic or problem. It might discuss the general applications of the topic or it might introduce the unique terminology associated with the topic.
The body of your paper should address the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
The conclusion should summarize your thoughts about what you have determined from your analysis in completing the assignment. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
Include any tables of data or calculations, calculated values, and/or graphs referenced in the paper. (Note: The minimum required length excludes any tables, graphs, etc.)
Document formatting, citations, and style should conform to the CSU-Global Virtual Library CSU-Global Guide to Writing and APA: Introduction. A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper. In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab has many helpful areas (Writing Center, Writing Tips, Template Examples/Papers Essays, Figures and Tables, and others).
by | Jul 30, 2022 | Mathematics
From Professor:
You will create and distribute a survey, analyze the data from the survey, and present your findings in both a written and presentation format. The survey must have three questions. It should be a mix of one numerical question and two categorical questions. The survey must have a theme.
The survey must collect data from a minimum of 25 people. It is recommended that you use some sort of online method to collect the survey data such as Google Forms or Survey Monkey. Methods for distributing surveys include using social media platforms.
You must submit a written report of the results of the survey, which will include the following:
