You will analyze the data you collected and provided in your assignment last week. As you are working on each of the steps below, think about the analysis that you will provide to the research team. Follow the steps below to complete this analysis.
Copy the file you created in week 5 and rename the new one “YourName_COMP150_W6_Assignment”.
Open the file and duplicate the sheet where the initial table and data were created
Rename the new sheet as “sorting & filters” and move it to the right of the original sheet
Make the data look professional by using formatting options such as borders and table styles to place the data into a table.
Select one of the text-based data columns such as names, cities, or addresses and sort the data by Z to A.
Create a custom filter to any part of the data except where you did the sort. For example, if you sorted by patient’s name, then filter another set of data.
Duplicate the original sheet again and rename it as “conditional formatting”. Move it right after the “sorting & filters” sheet.
Implement conditional formatting to any of the number-based data sets. For example, showing higher numbers in green, while showing lower numbers in red.
Add an IF function and apply it to the entire set. For example, you could create a function that says if x number is higher than x number, then you are at risk. The purpose is to show how an IF function works so creativity it is permitted in how you use the function.
Use the “conditional formatting” sheet to create a pivot table.
The pivot table needs to be on its own sheet.
The pivot table needs to be meaningful so make sure to select data that will make it clear for your analysis.
The pivot table should have data selected on the columns, rows, and values fields. Make sure to consider the data when adding the values selection
Create a minimum of two charts. Make sure to select the right chart that explains your analysis. Each chart should be on its own sheet and should have a title. Make sure the purpose of the chart is self-explanatory just by looking at it.
Update the documentation sheet
Update the date.
Add all the new rows for the sheets created.
Provide a brief written analysis for each of the new sheets. Explain what you want the research team to learn about each sheet.
Review all the sheets to ensure it looks professional. Try to keep the same style, colors, and formatting, Make sure the file is named “YourName_COMP150_W6_Assignment” and submit the file
EX16_AC_COMP_GRADER_CAP_HW – Drivers and Insurance
Project Description:
In this project, you will add fields to a table and set data validation rules. You will also import a text file into a database, design advanced queries, and create a navigation form. Additionally, you will use SQL to modify a record source and create an embedded macro to automate opening a report.
Start Access. Open the file named exploring_acap_grader_h1_Drivers.accdb. Save the database as exploring_acap_grader_h1_Drivers_LastFirst.
Create a table in the database by importing the downloaded delimited text file named Insurance_Text.txt. Use the first row of the file as field names, use InsuranceID as the primary key, and then name the table InsuranceCos_Text. Accept all other default options. Do not save the import steps.
Create a new field in the Agency Info table after InsPhone named Web site with the Hyperlink data type. Save the table. In Datasheet view, add the website http://William_Smith.com to the William Smith record (Record 1).
Create a new field in the Agency Info table after Web site named AgentPhoto with the Attachment data type. Save the table. In Datasheet view for Record 1 (William Smith), add the downloaded picture file named a00c2WmSmith.jpg to the AgentPhoto field.
Set the validation rule of the InsuranceCo field to accept the values AS, NAT, or SF only. Set the validation text to read Please enter AS, NAT, or SF. (include the period).
Make InsuranceCo a lookup field in the Agency Info table. Set the lookup to get values from the InsuranceID field in the InsuranceCos_Text table. Accept all other defaults and save the table. In Datasheet view, click in any InsuranceCo cell and click the arrow to view the options. Close the table.
Create a new query using Design view. From the Insurance table, add the DriverID, AutoType, TagID, and TagExpiration fields (in that order). Save the query as Missing Tag Dates.
Set the criteria in the TagExpiration field to find null values. Run the query (two records will display). Save and close the query.
Create a new query using Design view. From the Drivers table, add the Class field. Change the query type to Update and set the criteria to update drivers whose class is Minor to Junior. Run the query (eight records will update). Save the query as Driver Class_Update and close the query. View the updates in the Drivers table and close the table.
Create a new query using Design view. From the Drivers table, add the Class field. Save the query as Driver Class_Delete.
Change the query type to Delete and set the criteria to delete drivers whose class is Special. Run the query (one record will be deleted). Save and close the query. View the changes in the Drivers table and close the table.
Create a new query using Design view. From the Insurance table, add the DriverID, AutoType, AutoYear, and TagID fields (in that order). Save the query as Auto Year_Parameter.
Set the criteria in the Auto Year field to display the prompt as Enter the auto year: and run the query. In the prompt, enter 2007 and click OK to view the results (two records). Save and close the query.
Use the Analyze Performance tool to analyze the Drivers table. Note the idea to change the data type of the Weight field from Short Text to Long Integer. In the Drivers table, set the data type of the Weight field to Number (Long Integer), and save and close the table.
Create a Navigation form based on the Vertical Tabs, Left template. Drag and drop the Drivers form onto the first tab of the form. Drop the Insurance form onto the second tab.
Drag and drop the Drivers report onto the third tab of the Navigation form. View the form in Form view, click each of the tabs, and then save the form as Navigator. Close the form.
Open the Drivers report in Design view. Modify the record source of the report using a SQL statement to select all Drivers records with a Class of Adult. Print Preview the report (eight records will display). Save and close the report.
Open the Drivers form in Design view, click to add a command button at the intersection of the 6-inch mark on the horizontal ruler and the 3-inch mark on the vertical ruler.
Set the command button to open the report named Drivers. Use the default picture as the button. Set the name and the caption properties of the button to Open Drivers Report. Save the form. View the form in Form view, and click the command button.
Close all database objects, close the database, and then exit Access. Submit the database as directed
COMPUTING Database Programming and Implementation Please Print Clearly In CAPITALS Surname First Name Student ID Signature Student Code of Conduct University students have a responsibility to be familiar with the Student Code of Conduct: https://policies.mq.edu.au/document/view.php?id=233 Student Support University provides a range of support services for students. For details, visit http://students.mq.edu.au/support/ The background knowledge for the assignments is given in the textbook(s), lectures, any other components of the unit, in the prerequisite units ISYS114 or COMP1350, and in the readings provided on ilearn. However, some parts of the assignments may not be answered without prior independent research and/or searching for other sources of information. This assignment concerns database programming and implementation. It will be marked out of 100 and will contribute 10% towards your final grade. It consists of developing procedures and triggers in MySQL, creating and populating the database tables, and running test scripts against the tables. The description of the Problem domain is given below. 1 Problem Domain The context of this Assignment is the same as for Assignment 2, namely the Magic Ale (MA). This has been reproduced as is in the Appendix for your convenience. A DDL script (A3createDB.sql) for creating the corresponding database, and a DML script (A3populateDB.sql) for populating this database with some sample data are being provided in the Assignment 3 folder. 2 Task Specifications Task 1 (10 marks) Create the tables in the Magic Ale database by running the DDL script provided in the ‘Assignment 3’ folder. Then insert some sample records into the tables by running the provided DML script. Verify that the tables are created and populated as intended. Task 2 (30 marks) The membership records in the Membership table can be updated using an UPDATE statement. Such a statement can update any non-PK column value including the membership levels, but the Magic Ale has certain rules about membership level upgrades: • Only those members with a non-expired membership can receive an upgrade. • Only the SILVER members can be upgraded to the GOLD level. • Only the GOLD members can be upgraded to the PLATINUM level. • There is no further upgrade for the PLATINUM members. You will write a BEFORE UPDATE trigger called CHECK_MEMBERSHIP_UPDATE which fires when a record is attempted to be updated in the Membership table. The trigger has to check the conditions above to make sure that they are satisfied by the update request. If the above conditions are satisfied, then the UPDATE statement is allowed to proceed. Otherwise, a meaningful message needs to be displayed to the user. Note that a membership level can also be downgraded in a similar fashion but you are not responsible for checking the downgrading rules. Task 3 (30 marks) In this task, you will write a procedure called BrandNameCampaign which takes a brand name as input and creates a new campaign with the top 5 most expensive products with that brand name. The campaign will have a 4 week duration and will start after exactly two weeks of its creation. For the campaign, the SILVER level members will receive a 10% discount, the GOLD level members 20% and the PLATINUM level members 30%. If there are five or fewer products with that brand name, all those products will be included in the campaign. Task 4 (30 marks) This task involves testing the code developed in Tasks 2 & 3. Part (a) (10 marks) First you are required to test the programs you wrote against the sample data provided as part of Task 1 to see if they work. These data constitute a minimal test against a very small number of records and are unlikely to demonstrate the full functionality of your programs. Part (b) (20 marks) Next you carry out a more extensive test by testing the programs against a larger set of records that are designed by you to easily expose any flaws in your programs. You do that by deleting records, adding records, or modifying the records in other ways, and then calling different procedures and/or firing the trigger. 3 Report Specification You will also prepare and submit a report (in the PDF format). A word file template for this purpose will be provided which you will complete, convert to pdf, and submit. The file you submit will be named: yourLastname_yourFirstname _report.pdf. Your report should have the following sections: 1. The initial State of the database as created in Task 1: Paste to the word file the screen shots showing the provided sample data in the tables. Do not change any of the table or column names given in the provided DDL script. 2. Stored Programs: Paste into this section the programs you wrote (the contents of the SQL file yourLastname_yourFirstname _programs.sql that you prepared for Tasks 2 & 3). 3. Required Testing against the sample dataset as required in Task 4 Part (a): Paste into this section your SQL statements for the initial tests you ran (one by one) and then the corresponding results as screenshots. Also place your SQL statements into a file called yourLastname_yourFirstname _testscript.sql 4. More Extensive Testing as required in Task 4 Part (b): Explain what sort of changes you are going to make to which tables, what tests you are going to run, and why. Paste into this section your SQL statements for the extensive tests you ran (one by one) and then the corresponding results as screenshots. Also place all of your SQL statements into yourLastname_yourFirstname _testscript.sql. 5. Notes (optional): In this section, you might wish to note anything, such as whether you faced any particular difficulty in completing any of these tasks, the nature and extent of any help you received from anyone, and why. Remember to convert the report Word file to pdf and submit only the pdf file. 4 Your Submission You will submit three files: 1. yourLastname_yourFirstname _report.pdf. 2. yourLastname_yourFirstname _programs.sql 3. yourLastname_yourFirstname _testscript.sql. You will submit the files in two stages. In the first stage, as a minimum, you must submit the following two draft files by Tuesday, October 26, 2021, 11:55 PM (Week 12): a) yourLastname_yourFirstname _programs.sql including either the trigger CHECK_MEMBERSHIP_UPDATE or the procedure BrandNameCampaign in it, and b) yourLastname_yourFirstname _report.pdf, with complete Section (1) and partially complete sections (2) and (3). You can modify these files while preparing your final version. The final version of these three files must be submitted by Friday, October 29, 2021, 11:55 PM. Note Regarding Draft Submission. You are strongly suggested to submit a draft of your work by the “Draft Submission Due Date”. Students who have not submitted a draft will not qualify for special consideration should they not be able to submit by the deadline due to technical issues such as failure to connect to the Database Server. Late Submission Policy. No extensions on assignments will be granted without an approved application for Special Consideration. Late submissions will be accepted up to three days after the deadline, but there will be a deduction of 10% mark for each day (whole or part) of delay, unless you have received special consideration. If special permission is granted for a delay of more than three days, the student’s mark for this assignment will be calculated based on their overall performance in the Final Exam. Please see the Unit Guide for details. Appendix: Problem Context from Assignments 1 & 2 This assignment concerns a liquor shop chain in Sydney, called The Magic Ale (MA). The objective of this assignment is to develop a database system that will be used to centrally store and manage all relevant information for the branches of MA. The information to be stored include information on different branches of MA (Bankstown, Hornsby, etc.), types of drinks they sell (beers, wines, cedars, etc.), staff they employ (Retail Assistants, Shelving Assistants, etc.), Magic Members (MA Loyalty Card holders), and Sales Campaigns (discounts on specific products over a limited period). The basic requirements gathered from the stake holders is presented in the following five points. As typically the case, these requirements are often underspecified. Use your judgment in interpreting them when required, and keep a note of the assumptions you made. 1. Branch Information: The MA System shall keep information on each branch including its name and address, and the number of employees who work there. The system shall also contain information on which days (Mon-Sun) the branch is open, and opening hours. It will also keep information on opening hours (e.g., Mon-Fri 10:00AM-5:30PM; Sat 9:00AM-9:00PM; Sun Closed). 2. Product Information: The system shall contain relevant information on products of different types at the “item level”, such as: type (wine/beer/spirit/…), packaging info (can/bottle/…), volume (e.g., 375ml X 6 pack), price, and brand (e.g. Tooheys Old Dark Ale), as well as current stock level. 3. Staff Information: The system shall record information on staff members who work at different branches of MA. This will include their roles, type of employment (e.g. permanent, casual), salary (annual or hourly depending on permanent or casual), as well as who they report to. 4. Membership Information: The system shall record information on magic members, including type of membership (Platinum/Gold/Silver), and when the membership will expire. 5. Sales Campaign Information. The system shall keep information on sales campaign. Assume that these campaigns are global (same across all branches of MA). It will have information of the form: campaign start date and campaign end date, what items are on sale, and the discount for customers based on their membership (e.g., nonmembers 10%, Silver 15%, and Platinum/Gold 20%) 5. Sales Campaign Information: The system shall keep information on sales campaign. Assume that these campaigns are global (same across all branches of MA). It will have information of the form: campaign start date and campaign end date, what items are on sale, and the discount for customers based on their membership (e.g., nonmembers 10%, Silver 15%, and Platinum/Gold 20%)
Timely Delivery- primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals
Criminal Justice agencies often gather large quantities of variables to be used in descriptive analyses. That is, to help describe situations, populations, and so on. For instance, the Department of Corrections collects data on inmates. Variables often include crime type, race, gender, originating jurisdiction (where they were convicted), education level, and many others.
These data are often captured categorically rather than numerically. For instance, education level might be captured by simply identifying the name of the highest grade an offender achieved, such as high school diploma or GED, Bachelor’s degree, Associates degree, and so forth. Similarly, race data are most often captured by recording the label of the race the offender belongs to, such as Caucasian, African American, Asian, Native American, Pacific Islander, and so on. These labels have no inherent numerical value because they are simply categories. Thus, they are categorical variables.
You cannot use traditional statistical analysis to investigate relationships between categorical variables because they are not numbers. Instead, you would use nonparametric tests, such as the chi-square test of independence. You will use this test to investigate the data below.
This assignment has 2 steps.
Step 1: Watch both of the following videos regarding chi-square analysis:
Filling Out Frequency Table for Independent Events
Contingency Table Chi-Square Test
Step 2: Calculate chi-square using the data in the table below, this Chi Square Example Handout, and the Distribution Values Chart that go with this IP.
Using the Chi-Square Example Handout and the Chi-Square Distribution Values Chart as guides to figure the calculations, calculate chi-square for the following data:
Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Filling Out Frequency Table for Independent Events
Problem Set with questions designed to measure mastery of the content of the module. Each Problem Set has two (2) documents: Problem Set (questions) and Excel Template. Excel is the industry standard for finance work and is required to complete and submit each Problem Set. The provided Excel Template may be used or you may create an original spreadsheet. If you choose to use the Excel template provided, download it for better usability. Every question should have its own tab. Show all your formulas as this allows the instructor to better assess how to help you and award partial credit as deems appropriate.
Week 1 – Introductions, Financial Statements, and Ratios
This problem set uses Alaska Air Group, Inc. as the basis for ALL questions. To start, go to the airline’s investor relations page and get its latest annual report (10-K).
1. Using the firm’s selected financial data:
a. Make a table showing the income statement (in million $). Note that any expenses that do not have their own specific line listed should be grouped under “All other expenses”. The net income lines must tie using formulas.
b. Use the table created to create a common size income statement (as a % of operating revenues for that year).
c. Show year-on-year (YoY, in %) growth
d. What happened to the profit margins?
e. What are the actual tax rates?
2. Using the operating stats, what is the YoY growth rate for: a. Yield?
b. Operating expense per available seat mile (CASM)? c. Revenue passenger miles (RPMs)?
d. Fuel price ($/gallon)?
e. Considering the above, what factors, other than the pandemic, do you think are
3. Using the firm’s balance sheets, show:
a. Balance sheets as shown (in million $); show only net property & equipment lines.
b. Common size balance sheets.
c. Are there any outliers in the balance sheets that you think merit mentioning?
d. For these years, what is the net working capital position? Current ratio? Quick ratio? Total debt ratio? Return on assets (ROA)? Return on equity (ROE)? What is the latest p/e ratio (use Yahoo Finance)?
4. Using the Statement of Cash Flows, which items stand out to you and why?
a. What are the top three markets by share? b. What happened to passenger yields?
c. What happened to costs per ASM?
d. What do you think this means for the bottom line? e. What are the top three city pairs?
Week 2 – Discounted Cash Flow Valuations and Net Present Value
Remember that when you use the perpetuity formula, the formula automatically present values the perpetuity one period, so if you use the perpetuity formula in year 15, the result is as of the beginning of year 15!
1. You are offered three annuities (these make equal payments over a specific period). Using an annual 5.5% discount rate, calculate each annuity’s price:
#
Price ($)
Payments ($/month)
Life (years)
1
?
195
6
2
?
200 (growing @ 1%/year)
5
3
?
135 (growing @ 2.5%/year)
Forever
2. You purchase a new machine for your firm. It costs $84,000 and will expand your cash flow by $13,500/year in year 1 growing by 2.5% per year after that. The system will work for 30 years before you have to replace it. What are the NPV (at a 5.5% discount rate) and IRR?
The vendor offers you another machine costing $99,000 and lasting 35 years, with the same yearly cash flow and growth rate. What are the NPV and the IRR for it? Should you get it?
a. Use July 1, 2011, to calculate the future value of the $5.9M owed on July 1, 2000.
b. Use July 1, 2011, to calculate the present value of the 25 yearly payments of
$1,193,248.20. The first payment is made on July 1, 2011
c. Should Bobby take it? Why?
4. You are looking to lease a car. The dealer offers you the following: Car price = $35,000
Monthly lease payments = $499
Down payment = $3,000
Lease term = 36 months
Purchase price at end of lease = $18,000
What is the implicit interest rate on the lease?
5. The Airbus A220 has the following R&D costs (all negative cash flows):
€400M (year 1)
€300M (year 2)
€200M (year 3)
€100M (year 4)
Each plane will be sold for €48M – 15% down and the rest due on delivery one year later. The cost to produce each plane is €38M – these costs are recognized on delivery. The Sales and Marketing Department says that you will sell 30 planes (year 5) and sale will grow by 5 planes per year before they plateau at 60 planes. The last sale is made in year 16, when the A220 is replaced by a new model.
What are the NPV (as of the beginning of year 1) and the IRR of the plane using a 9% discount rate?
Week 3 – Risk Analysis, Real Options, and Capital Budgeting
1. Real Options
A. JTMAirlinesislookingatbuyingmoregatesattheirhomeairport.JTM’sdiscountrateis 5.5% and the risk free rate is 2.0%. What is the NPV of the gate purchases if it bought them today? Use the data in the Excel template provided.
B. After you run the numbers for part A, you remember back to the concept of real options, which means that JTM can make investment decisions as time passes:
1. Present valuing the purchase price of the gates (that is, the years 1 and 2 Capital Expenditures) separately using the risk-free rate. Once JTM decides to go ahead with the purchase, there is no risk to that expenditure.
2. Present valuing the Net Cash Flow excluding those purchase prices. This calculation will include Cap. Ex. for years 3-15 as they are part of the normal operation of the gates and are unrelated to the purchase price.
3. Use the Black-Scholes Option Pricing formula to come up with option’s price assuming a 2-year maturity and a 15% price volatility for gate prices.
4. Compare the price of the call option with the NPV in the No Real Options scenario. Is the option worth it?
2. Decision Tree
JTM really liked your work on the option pricing of the gates, so they ask you to look at their 3- phase expansion at their home airport. The three phases are:
A. Uponpurchaseofthenewgates,startamarketingprogramtopromoteJTM’sroutesto the East Coast, West Coast, and the Caribbean. If all goes well and the market is receptive, they will go on to phase 2.
B. Phase2hasJTMinvestinnewroutestothedestinationslisted.Ifatanytime,JTM finds that this is not going to work, they will pull the plug on everything.
C. Phase3hasJTMstartthenewroutestothedestinationslisted.Ifthingsdon’tgowell on any of the three destinations, they will pull the plug on everything.
After much work with other departments, you generate enough data to calculate the NPV of the 3-phase expansion. Before you have a chance to save all your work, there is a power spike and you lose part of your work. You have to complete it for a presentation. Please use the Excel template provided to complete this.
Week 4 – Interest Rates and Bond Valuation
1. What is the annual yield of a 6-year, 6.4% semi-annual coupon-paying bond priced today at $1,190? Par is $1,000.
2. What is the annual yield of a 9-year, 4.1% annual coupon-paying bond priced today at $1,088? Par is $1,000.
3. Show the cash flows and prices for the following four bonds, each with a par value of $1,000 and paying interest semi-annually:
#
Coupon Rate
Years to Maturity
Market Yield
A
6.4%
8
4.5
B
3.7%
9
4.4
C
3.8%
9
4.6
D
0.0%
5
4.3
Which of the four bonds would you prefer to hold and why? (Answer in the box provided.)
4. Considerasemi-annualbondwithanannualcoupon=6.33%,maturity=10 years, par value = $1,000, and a market price today = $1,063:
a. Whatisitsyieldtomaturity(YTM)?
b. Supposethebondcanbecalledat$950attheendofyear8,whatis
itsyield to call?
5. You have two bonds with the following characteristics:
Characteristics
Bond A
Bond B
Coupon
4.4%
5.5%
Years to Maturity
7.5
5
Par Value
$1000
$1000
Price
$902.00
$911.00
a. Whatarethebonddurations?
b. Ifratesriseto4.5%,whatarethenewpricesforeachbond?
Week 5 – Valuing an Airline for Acquisition
JTM Airlines, a privately held firm, is looking to buy additional gates at its home airport for $1,500,000. It has money in the bank, but that money may not be spent as it is used to pay salaries, suppliers, and equipment. It asked its bank for a loan, but the bank refused unless the project had a return higher than JTM’s weighed average cost of capital. Separately, PAN Airways’s CEO approached JTM’s CEO to sell the airline. As a result of all this, JTM has contracted you to:
1. Calculate JTM’s weighed average cost of capital (WACC) based on two airlines trading in the capital markets – PDM and GAL. Since JTM does not trade, it has no beta, so you need to use these two firms as proxies. JTM’s CFO kindly gave you the necessary information on PDM and GAL for you to do this.
2. Aside from the purchase price, the gates will require a working capital infusion of $1,500,000 at purchase. JTM estimates the gates will generate cash flows of $295,500 in year 1, inflating at 4%/year over the next 12 years. After that, the gates will revert back to the airport operator. Half the working capital is recovered at the end. Calculate the NPV and IRR of the gates.
3. You were given PAN’s 2020 income statement (IS) and balance sheet (BS), along with forecasts of the revenue growth. Forecast the IS and BS for the next 5 years.
4. The price discussed by the two CEOs is $6.5M. You must value PAN Airways using free cash flows to see if this price is fair or not.
Week 6 – Multiples and Transactions, Dividend Discount Model
1. JTM Airlines is looking to buy Jaguar Airlines. Your boss, the CFO, wants a quick and dirty valuation of Jaguar. You choose to look at past transactions in the airline industry to get some numbers and put them in an Excel spreadsheet. For Jaguar, you find out the firm’s key financial values and put them in the spreadsheet. To remind yourself that they are inputs, you should color them red.
Using EPS, Book Value (BV), Sales, EBITDA, Premium and Synergy over stock price,what should be Jaguar’s prices per share?
2. Yourbossispilingontheworkandhasaskedyoutovaluethreemore potential acquisitions. They are of Northern, Eastern and Central, fixed base operators serving areas where JTM is looking to expand (the names give away the regions of the country). You don’t have cash flow data for these firms as they are privately held, but you talked to the owners and they gave you dividend information for the firms, which you entered into your spreadsheet. You remember back to your corporate finance class that you can use the Dividend Discount Model (DDM) to come up with a quick and dirty valuation.
You know that JTM’s WACC is 6.8% and will use this as the applicable discount rate.
Using the DDM Model, what are the values per share of each of these three firms?
Week 7 – Long Term Debt
1. A firm issues a $10 million debt obligation that pays 7.3% per year over four years. How much will it have to pay in four years?
2. Suppose that a life insurance company has guaranteed a payment of $14 million to a pension fund 4.5 years from now. If the life insurance company receives a premium of $10.4 million from the pension fund and can invest the entire premium for 4.5 years at an annual interest rate of 6.25%, will it have sufficient funds from this investment to meet the $14 million obligation?
3. A. A firm is borrowing $5,000,000 from its bank at an annual interest rate of 5.7% for the first six years and 7.2% for four years after that. How much will it pay at the end?
B. Suppose the firm in 3A can take another bank’s quote of $5,000,000 for 10 years at an annual rate of 6.1% compounded semiannually. How much would it pay at maturity? Is this investment alternative more attractive than the one in 3A?
4. Suppose a firm issues a $10 million debenture maturing in 8 years and with an annual rate of 7%. Interest is paid annually at the end of the year. How much will the firm have paid out in total as of year 8, when it pays the interest plus principal?
5. A firm’s head of HR knows that the following pension payments must be made in years 1- 4. The head of HR needs to go to management to request a lump sum that will satisfy this liability stream. Assuming the lump sum can be invested today at an interest rate of 4.7%, how much must be invested today to satisfy this liability stream?
Week 8 – Short Term Debt
1. You are in a team compiling a report to send to your firm’s bank. You are supposed to take the firm’s last three months and provide the following for each month:
Days receivable Days inventory Operating cycle Days payable Cash cycle
You have all the financials in the spreadsheet so all you need to do is make the calculations.
2. ABC Maintenance Service
A. ABC FBO sells maintenance services to various private jet operators.
For these, it demands payment within 30 days. It is considering changing this policy to 0.66%/7, net 30. What is the implicit annual rate in the new policy? Use a notional purchase of $10,000.
B. ABC’smaintenanceservicebusinessgrossessome $22M per year before discounts and its average days receivable is 30. If 15% of its clients opt to follow the new policy, what will be the change in receivables? If ABC’s WACC is 7.0%, what are the projected savings of the new policy? If its gross margin is 22%, by how much will gross dollar revenues have to rise to offset the loss from discounts? In percent?
Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Make a table showing the income statement (in million $). Note that any expenses that do not have their own specific line listed should be grouped under “All other expenses
Case Analysis: Determine whether certain contract remedies exist in the following scenario: Forrest Gump is a famous table tennis player. He enters into a contract with Alabama Sports Marketing to advertise the latest ping pong game and to serve as the computer-generated imagery (CGI) model for the development of the video game. Gump is perfect for this job as there are not many world famous ping pong players who have a following similar to his. The game is set to start development on March 1 and will be completed on July 31, so the game can be released at Thanksgiving—a major video game release period. Both parties have agreed and stipulated to the fact that the game must be completed on time to maximize the profits.
Gump will make 20% of the net proceeds from the sales of the game. In addition, the contract has a liquidated damages clause that indicates that if Gump does not participate in the marketing, does not serve as the CGI model, or breaches the contract in any way, he will owe Alabama Sports Marketing $2 million.
Based on this fact pattern and the information presented in this unit, answer the following questions. Your response must be at least two pages in length and utilize key legal terms in contract law.
One day, Gump gets into an argument with the developer. Gump refuses to perform any work until the problem is solved. In this situation, can Alabama Sports Marketing seek specific performance of the contract? If yes, why? If no, why not? How would the court determine whether the liquidated damages clause is valid? Is this clause valid? Explain your answers. Evaluate the equitable and legal remedies available for breach of contract. One source is required for your paper. Include an introduction in your paper. Adhere to APA Style when creating citations and references for this assignment. APA formatting, however, is not necessary.
A contract is a fundamental part of any business dealing, whether online or not. Contracts are relationships between two or more business entities that are legally binding and enforceable by law such that in case of any breach of contract, the injured entity can seek damages legally.
A breach of a contract violates such a relationship by one entity by failing to honor the terms stated in the contract. A breach of contract can happen in both an oral and a written contract and may take any form from late payment to failure to deliver on assets. In this context, the entities involved may find solutions amongst themselves or in a court of law.
A breach of contract can either be minor or material. A minor breach is where one party does not receive a good or service by the due date, whereas a material breach is where one party receives an item different from what was stipulated in the contract. Furthermore, a breach of contract can either be categorized as actual or anticipatory.in case of an actual breach, one entity fails to perform according to contract stipulation, while in anticipatory breach, a party clearly states their intention of not delivering on the contract terms.
Remedies for breach of contract
Remedies for a breach of contract are the actions taken in the event of a contract violation by one or more parties to a contract. The purpose of remedies is to compensate the non-breaching party and return them to a position they would have been in if the breach did not happen.
Types of remedies for breach of contract
Damages
Damages are money paid to the non-breach party, which may be nominal or substantial. Nominal damages are paid when the non-breach party does not suffer any loss due to the breach. Additionally, substantial damages are awarded when one party suffers a loss resulting from the other party’s breach. Moreover, damages may be compensatory or punitive, where the former is tailored to cover the non-breaching party for damages directly caused by the breach. In contrast, the latter is designed to punish the faulty party for causing the breach to prevent others from committing the same breach. Punitive damages are included together with compensatory damages but have to be decided by a court of law.
Restitution
Restitution is a remedy used to return the non-breaching party to a position they were before the contract. Here, the party who breached the contract must give back any property or monies from the other party, as stipulated in the contract. However, any lost profits that would have been yield by the contract are not included.
Rescission and Reformation
A rescission is a remedy that returns all parties to,…………………………………………………………………………………………………………………………………………………………………………………………………………………………………,………………………………………………………………………………………………………………………………………………………………………………………………………………………………… Forrest Gump is a famous table tennis player.
Determine whether certain contract remedies exist in the following scenario: Forrest Gump is a famous table tennis player. He enters into a contract with Alabama Sports Marketing to advertise the latest ping pong game and to serve as the computer-generated imagery (CGI) model for the development of the video game. Gump is perfect for this job as there are not many world famous ping pong players who have a following similar to his. The game is set to start development on March 1 and will be completed on July 31, so the game can be released at Thanksgiving—a major video game release period. Both parties have agreed and stipulated to the fact that the game must be completed on time to maximize the profits.
Gump will make 20% of the net proceeds from the sales of the game. In addition, the contract has a liquidated damages clause that indicates that if Gump does not participate in the marketing, does not serve as the CGI model, or breaches the contract in any way, he will owe Alabama Sports Marketing $2 million.
Based on this fact pattern and the information presented in this unit, answer the following questions. Your response must be at least two pages in length and utilize key legal terms in contract law.
One day, Gump gets into an argument with the developer. Gump refuses to perform any work until the problem is solved. In this situation, can Alabama Sports Marketing seek specific performance of the contract? If yes, why? If no, why not? How would the court determine whether the liquidated damages clause is valid? Is this clause valid? Explain your answers. Evaluate the equitable and legal remedies available for breach of contract. One source is required for your paper. Include an introduction in your paper. Adhere to APA Style when creating citations and references for this assignment. APA formatting, however, is not necessary. See famous table tennis player
A contract is a fundamental part of any business dealing, whether online or not. Contracts are relationships between two or more business entities that are legally binding and enforceable by law such that in case of any breach of contract, the injured entity can seek damages legally.
A breach of a contract violates such a relationship by one entity by failing to honor the terms stated in the contract. A breach of contract can happen in both an oral and a written contract and may take any form from late payment to failure to deliver on assets. In this context, the entities involved may find solutions amongst themselves or in a court of law.
A breach of contract can either be minor or material. A minor breach is where one party does not receive a good or service by the due date, whereas a material breach is where one party receives an item different from what was stipulated in the contract. Furthermore, a breach of contract can either be categorized as actual or anticipatory.in case of an actual breach, one entity fails to perform according to contract stipulation, while in anticipatory breach, a party clearly states their intention of not delivering on the contract terms.
Remedies for breach of contract
Remedies for a breach of contract are the actions taken in the event of a contract violation by one or more parties to a contract. The purpose of remedies is to compensate the non-breaching party and return them to a position they would have been in if the breach did not happen.
Types of remedies for breach of contract
Damages Damages are money paid to the non-breach party, which may be nominal or substantial. Nominal damages are paid when the non-breach party does not suffer any loss due to the breach. Additionally, substantial damages are awarded when one…………………………………………………………………………………………………
STATISTICAL ANALYSIS (MAT10251) ASSESSMENT 2 – CALCULATIONS AND SHORT WRITTEN RESPONSES (30%) INSTRUCTIONS Perform and show the required calculations, present your findings, and prepare short written responses to the following questions. Please submit your answers in a single file. Question 1 – Basic Probability (10 marks) According to a recent study, 9 out of 10 parents have helped their adult children with some financial assistance. The following table shows the number of times parents have given their adult children financial assistance to buy a car and to pay the rent. Pay the rent Yes No Buy a car Yes 90 50 No 10 150 a. Develop a joint probability table. (2 marks) b. Using the marginal probabilities for ‘buy a car’ and ‘pay the rent’, are parents more likely to assist their adult children with buying a car or paying the rent? What is your interpretation of the marginal probabilities? (2 marks) c. If parents provided financial assistance to buy a car, what is the probability that the parents assisted with paying rent? (2 marks) d. If parents did not provide financial assistance to buy a car, what is the probability that the parents assisted with paying rent? (2 marks) e. What is the probability that parents provided financial assistance for their adult children by either helping to buy a car or pay rent? (2 marks) Question 2 – Normal Distribution (10 marks) The time needed to complete a final examination in a particular college course is normally distributed with a mean of 160 minutes and a standard deviation of 20 minutes. Answer the following questions: a. What is the probability of completing the exam in 120 minutes or less? (2 marks) b. What is the probability that a student will complete the exam in more than 120 minutes but less than 150 minutes? (2 marks) c. What is the probability that a student will complete the exam in more than 100 minutes but less than 170 minutes? (2 marks) d. Assume that the class has 120 students and that the examination period is 180 minutes in length. How many students do you expect will be unable to complete the examination in the allotted time? (4 marks) 1 Question 3 – Sampling Distribution (10 marks) The Economics Policy Institute periodically issues reports on wages of entry-level workers. The Institute reported that entry-level wages for male college graduates were $43.36 per hour, and for female college graduates were $37.60 per hour. Assume the standard deviation for male graduates is $2.30 and for female graduates is $2.05. a. What is the probability that a sample of 50 male graduates will provide a sample mean within $0.50 of the population mean, $43.36? (3 marks) b. What is the probability that a sample of 50 female graduates will provide a sample mean within $0.50 of the population mean, $37.60? (3 marks) c. In which of the preceding two cases, part (a) or part (b), do we have a higher probability of obtaining a sample estimate within $0.50 of the population mean? Why? (2 marks) d. What is the probability that a sample of 120 female graduates will provide a sample mean more than $0.30 below the population mean? (2 marks) 2
Determine whether certain contract remedies exist in the following scenario:
Forrest Gump is a famous table tennis player. He enters into a contract with Alabama Sports Marketing to advertise the latest ping pong game and to serve as the computer-generated imagery (CGI) model for the development of the video game. Gump is perfect for this job as there are not many world famous ping pong players who have a following similar to his. The game is set to start development on March 1 and will be completed on July 31, so the game can be released at Thanksgiving—a major video game release period. Both parties have agreed and stipulated to the fact that the game must be completed on time to maximize the profits.
Gump will make 20% of the net proceeds from the sales of the game. In addition, the contract has a liquidated damages clause that indicates that if Gump does not participate in the marketing, does not serve as the CGI model, or breaches the contract in any way, he will owe Alabama Sports Marketing $2 million.
Based on this fact pattern and the information presented in this unit, answer the following questions. Your response must be at least two pages in length and utilize key legal terms in contract law.
One day, Gump gets into an argument with the developer. Gump refuses to perform any work until the problem is solved. In this situation, can Alabama Sports Marketing seek specific performance of the contract? If yes, why? If no, why not? How would the court determine whether the liquidated damages clause is valid? Is this clause valid? Explain your answers. Evaluate the equitable and legal remedies available for breach of contract. One source is required for your paper. Include an introduction in your paper. Adhere to APA Style when creating citations and references for this assignment. APA formatting, however, is not necessary.
a. Include a copy of YOUR regression results with the project. Make AND document any necessary improvements to your original regression results. Construct a 4×4 table with your explanatory spreads listed in each row and the answers to parts b, c, and d for the columns.
b. Comment on the coefficients signs and describe the relationships between the independent and explanatory variables of your final set of regression results. c. Carefully explain whether the relationships you found make intuitive economic sense.
d. Comment on the likelihood that any variable explains dependent variable movements.
e. Summarize the results. What factor(s) contribute to a non-zero [BEIt – (INFL_SWAP_RATE)] basis? What factor(s) is most likely to impede the FOMC’s ability to determine a reasonable gauge of inflation expectations when formulating its monetary policy strategy? Explain.
