Category: Finance

This is a report which should be done in excel which is based on the company “Southern Copper Corp (SCCO.N)”
Please find requirements in the attachments and the template you are able to use to finish this report.
Please use the company information to complete the report.

Take some 5 stocks from yahoo finance database
run correlation matrices, interpret the results 
using the Eviews software, which we used in the class, run Granger causality and Vector Autoregression (VAR) and comment on how the underlying assets (stocks) affect each other.
Interpret the results in two pages and submit.

Project #1: Aksoy (Senior Living)

Your task is to produce a business challenge report by week#8 which will be submitted to Aksoy Holdings CEO Mr. Batu Aksoy. The report should be approximately 10 to 15 pages long (double spaced and with 12-point font) and include the following deliverables:
• Analyzing market research data, including demographics, competition, penetration rates, and demand analysis.
• Conducting a Highest and Best Use analysis.
• Creating a Project Proforma.
• Developing an Operating P&L.
• Evaluating exit options post-stabilization

Tesla, Inc Case Study
Overview:
In this assignment, you need to review the Tesla, Inc. case study. The case study
describes the rise of Tesla Motors, an electric vehicle company founded in 2004 by
electric inventor Martin Eberhard and South African innovator, Elon Musk. The case
details the motivation of the two men, their personalities, and the conflicts they went
through to develop the company. It also provides an overview of the challenges and
opportunities of competing in the electric vehicle space; discusses Tesla′s strategies for
manufacturing, marketing, and distributing the cars; and points to key questions about
Tesla′s future.
Instructions:
Review the Tesla Case Study. Also, feel free to utilize information from the Tesla videos
found in Reading and Resources in this unit.
Using Porter′s Five Forces model:
• Describe in detail the challenges and opportunities of competing in the electric
vehicle industry.
o You will need to create a section for each of the five forces when
answering the question in detail.
• Finally, describe Tesla′s strengths and weaknesses.
Requirements:
• Submit a two-three page Word document covering the elements of the
assignment.
• Develop a clear introduction, body, and conclusion. Use paragraph format and
transitions.
• Focus on the quality of writing and content.
• Use APA format with a title page, in-text citations, and references. Abstract not
required. The title page, reference page, and appendices are excluded in page
length requirement

White Company has two departments, Cutting and Finishing. The company uses job-order costing and computes a predetermined overhead rate in each department. The Cutting Department bases its rate on machine-hours, and the Finishing Department bases its rate on direct labor-hours. At the beginning of the year, the company made the following estimates:
Department
CuttingFinishing
Direct labor-hours7,60089,000
Machine-hours58,3002,800
Total fixed manufacturing overhead cost$ 370,000$ 512,000
Variable manufacturing overhead per machine-hour$ 3.000
Variable manufacturing overhead per direct labor-hour0$4.75
Required:
Compute the predetermined overhead rate for each department.
The job cost sheet for Job 203, which was started and completed during the year, showed the following: Department
CuttingFinishing
Direct labor-hours311
Machine-hours815
Direct materials$ 750$ 380
Direct labor cost$ 66$ 242
Using the predetermined overhead rates you computed in requirement (1), compute the total manufacturing cost assigned to Job 203.
Would you expect substantially different amounts of overhead cost to be assigned to some jobs if the company used a plantwide predetermined overhead rate based on direct labor-hours, rather than using departmental rates?

Gold Nest Company of Guandong, China, makes birdcages for the South China market. The company sells its birdcages through an extensive network of street vendors who receive commissions on their sales.
The company uses a job-order costing system that applies overhead to jobs based on direct labor cost. Its predetermined overhead rate is based on a cost formula that estimated $85,500 of manufacturing overhead for an estimated activity level of $45,000 direct labor dollars. The beginning inventory balances were as follows:
Raw materials$ 10,300
Work in process$ 4,500
Finished goods$ 8,200
During the year, the following transactions were completed:
Raw materials purchased on account, $161,000.
Raw materials used in production, $145,000 (materials costing $120,000 were charged directly to jobs; the remaining materials were indirect).
Employee expenses incurred (credit Salaries and wages payable):
Direct labor$ 167,000
Indirect labor$ 234,300
Sales commissions$ 22,000
Administrative salaries$ 48,000
Rent for the year was $18,800 ($13,400 related to factory operations, and the remainder related to selling and administrative activities).
Utility costs incurred in the factory, $14,000.
Advertising costs incurred, $13,000.
Depreciation on equipment, $23,000 ($16,000 related to equipment used in factory operations; the remaining $7,000 related to equipment used in selling and administrative activities).
Manufacturing overhead cost applied to jobs, $ ?question mark .
Completed goods cost $228,000 to manufacture.
Sales for the year (all paid in cash) totaled $505,000. The manufacturing cost of these goods was $216,000.
Required:
1. Prepare journal entries to record the transactions for the year.
2. Prepare T-accounts for each inventory account, Manufacturing Overhead, and Cost of Goods Sold. Post relevant data from your journal entries to these T-accounts (don’t forget to enter the beginning balances in your inventory accounts).
3A. Is Manufacturing Overhead underapplied or overapplied?
3B. Prepare a journal entry to close Manufacturing Overhead to Cost of Goods Sold.
4. Prepare an income statement. All of the information needed for the income statement is available in the journal entries and T-accounts you have prepared.

I would need a PowerPoint which would cover the following : For the first slide I would need a quick summary of the case explaining the context.
1.     Why does Air Berlin want to do an IPO?
2.     Do you think it is appropriate given their current situation and the industry?
3.     What value would you put on Air Berlin? To back up your answer, perform all relevant valuation techniques.
4.     What advice would you have for Air Berlin’s senior management in following through with the IPO? Would you delay the IPO? Would you lower the price range? 
Additionally, I would also need to include some financial data which would need to be done in Excel as it can’t be copy pasted.
Moreover, If you could make the ppt pretty that would be a plus !

This competency assessment addresses assessing the value of investment projects. The Arbitrage Pricing Theory helps calculate required stock returns considering a number of factors. In this Assignment, you will apply Arbitrage Pricing Theory to a business scenario.
Prepare this Assignment as a Word document. List each question followed by your answer.
Complete problem: Cost of Equity-CAPM
XYZ, Inc. has a beta of 0.8. The yield on a 3-month T-bill is 5%, and the yield on a 10-year T-bond is 7%. The market risk premium is 5.5%, and the return on an average stock in the market last year was 20%. What is the estimated cost of common equity using the CAPM? Show your work.
Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback
A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work.
What is the project’s NPV? (Hint: Begin by constructing a timeline).
What is the project’s IRR?
What is the project’s MIRR?
What is the project’s PI?
What is the project’s payback period?
What is the project’s discounted payback period?
Your division is considering two investment projects, each of which requires an up-front expenditure of 20 million. You estimate that the investment will produce the following net cash flows:
Year          Project A                       Project B
1               $5,000,000                    $20,000,000
2                10,000,000                    10,000,000
3                20,000,000                     6,000,000
What are the two project’s net present values, assuming the cost of capital is 5%? 10%? 15%?
What are the two projects’ IRRs at these same costs of capital?
Show your work.
Prepare this Assignment responding to the problems as an Excel® or Microsoft® Word®, showing all necessary formulas and steps. List each question, followed by your answer. Please submit this Assignment through the Dropbox.
The Module 3 Competency Assessment has 3 parts:
Part 1 Analyze the discounted cash flow approach
Calculate cost of equity using CAPM
Part 2 Apply the NPV equations of an investment to project its NPV
Calculate a project’s NPV
Calculate a project’s discounted payback period
Calculate a project’s IRR
Part 3 Estimate an investments Net Present Values
Demonstrate a project’s NPV assuming cost of capital at different percentages

Guidelines Project attach. The order includes an Excel, three discussion questions, and a 5 question project.     

Using google, yahoo finance or any other available source of financial information identify 12 firms that paid dividends.
The files attached below shows all the requirements for the project