Category: Finance

Complete the following problem from the textbook. Please submit as Excel. Complete 13-1A all 3 problems.

Course Project: Part 1 – Budget Spreadsheet Assignment
Instructions
You will develop an Excel spreadsheet with 5-year trend data
on a variety of key performance indicators and budget items showing the
financial status of the selected institution.
The US Department of Education’s National Center for
Education Statistics coordinates the Integrated Postsecondary Education Data
System (IPEDS) surveys every year. The IPEDS surveys are federal requirements
of all institutions that receive Title IV aid. IPEDS data are especially
helpful for enrollment and budget analysts to compare their own institutions
with comparative peer institutions. Use link: Retrieving IPEDS Data for
Selected Institutions in the Learn section for a helpful video tutorial
with the step-by-step instructions.
In this assignment, you will download data that are publicly
available from IPEDS (if you cannot locate the information from your own
institution’s website). Use the most recently available 5 years of reported
data for the following most important key performance indicators and budget
data that must be included in the spreadsheet:
1.    
Fall Enrollment
·      Enrollment of first time in college (FTIC) students
·      Enrollment of new transfer students
·      Total undergraduate enrollment
·      Total graduate enrollment
·      Full-time enrollment
·      Part-time enrollment
·      Grand total enrollment
2.    
Retention Rates
·      Full-time retention rate
·      Part-time retention rate
3.    
Completions
·      Bachelor’s degrees
·      Master’s and doctoral degrees combined
·      Grand total completions
4.    
Graduation Rates
·      150% of normal time
5.    
Student Financial Aid and Net Price
·      Number of undergraduate 
students awarded federal, state, local, institutional or other sources
of grant aid
·      Percent of undergraduate students awarded federal, state,
local, institutional, or other sources of grant aid
·      Average amount of federal, state, local, institutional, or
other sources of grant aid awarded to undergraduate students
·      Number of undergraduate students awarded federal student
loans
·      Percent of undergraduate students awarded federal student
loans
·      Average amount of federal student loans awarded to
undergraduate students
6.    
Frequently Used/Derived Variables
·      Total price for in-state students living on campus
·      Total price for out-of-state students living on campus
7.    
Finance
·      Revenues
i.     Tuition and fees
ii.     Sales and services of auxiliary enterprises
iii.     Total operating revenues
iv.     Gifts, including contributions from affiliated organizations
v.     Total nonoperating revenues
vi.     Capital grants and gifts
vii.     Total all revenues and other additions
·      Expenses and salaries and wages by function and total
expenses by natural classification
i.     Instruction current year total
ii.     Research current year total
iii.     Public service current year total
iv.     Academic support current year total
v.     Student services current year total
vi.     Institutional support current year total
vii.     Auxiliary enterprises current year total
·      Endowment assets
i.     Value of endowment assets at the end of the fiscal year
·      Assets and liabilities
i.     Total assets
ii.     Total liabilities
·      Plant, property, equipment
i.     Total for plant, property and equipment
ii.     Other capital assets – ending balance
You are welcome to provide additional information as a means
of preparing broader context about the institution. Because of the amount of
details required for this budget assignment, it is recommended that you use
multiple worksheets within the same Excel file instead of placing all the data
into the same worksheet.

Please read instructions carefully – there are calculations on each tab. Use reading references for analysis

1. The Toledo Technology Company is analyzing a proposed project. The company expects to sell 10,000 units, give or take 10 percent. The expected variable cost per unit is $6 and the expected fixed cost is $29,000. The fixed and variable cost estimates are considered accurate within a plus or minus 4 percent range. The depreciation expense is $25,000. The tax rate is 34 percent. The sale price is estimated at $13 per unit, give or take 6 percent. What is the expected net income under the best case scenario?
2. Alpha Investment Corporation., a Saskatchewan-based hedge fund, is planning to build a sports centre in Swift Current. The group spends $1,200,000 to buy land and to develop the parking lot. After completing these steps they terminate the project when they learn that another facility is going to be built close by. What option has the hedge fund exercised? Three years later, they still own the land and improvements.  How should they value these things if they decide at that time to complete the sports centre as originally planned?
3. The Melville Manufacturing Company has an inventory period of 58 days, an accounts payable period of 45 days, and an accounts receivable period of 25 days. How long is the company’s cash cycle? Generally speaking, what sorts of things could happen whereby this company might see a decrease in its cash cycle?
4. The Cypress Hills Furniture Corporation has a beginning cash balance of $482 on February 1st. The firm has projected sales of $550 in January, $700 in February, and $800 in March. The cost of goods sold is equal to 50% of sales. Goods are purchased one month prior to the month of sale. The accounts payable period is 30 days and the accounts receivable period is 15 days. The firm has monthly cash expenses of $200. What is the projected ending cash balance at the end of February? Assume that every month has 30 days.
5. Many organizations are now using online banking, payment apps, and other electronic means for making and receiving payments. What are the implications of this societal change on float management?
6. A company based in Montreal, Quebec has a cash balance of $35,000 as of June 1. During the month they paid $18,000 on account, $13,000 for wages, and $1,000 for other expense items. The company maintains a minimum cash balance of $10,000. Sales for the firm for April, May, and June are $15,000, $22,000, and $18,750, respectively. The company collects 50% of sales in the month of sale, 30% in the following month, and 20% in the second month following the month of sale. What is the cash surplus or deficit as of June 30, relative to the company’s required minimum cash balance?
7. Serena’s co-op placement is with a consulting company in Winnipeg, in the treasury department. The job has been interesting and has kept Serena quite busy. She thought she was really starting to understand how things worked, but recently a senior finance department staff member commented that “It is quite important for our company to maintain a minimum cash balance of approximately $250,000 at all times. Often the cost of holding this much cash is greater than the return generated by the funds. Still, we have to do this.” Serena was puzzled by the comment. How would you explain this to her?
8. The Jabez Corporation has asked for credit with your firm. Jabez has not done business with your firm previously, but the company’s operations manager has assured you that they will continue to do regular business with your firm. The company’s purchasing manager would like to buy some equipment today at a cost of $475,000, with 30 days credit. Your variable cost for that equipment is $460,000 and your monthly interest rate is 1.25 percent. Your research has shown that the probability of default for Jabez is 25 percent, which makes you a little reluctant to work with the company. What is the net present value of this decision? 

The Business Plan
Design a detailed business plan for a new product, service, or business venture of your choice. This could be an idea you have been contemplating or a product presently being marketed, but your business plan must reflect the uniqueness of the idea. For example, it might involve the modification of a certain product based on the unique needs of your community or peer group. Follow the business plan outline provided in Table 8.1 of the course textbook. Be sure to include:
Title page
Table of contents
Executive summary
Description of product, service, or business
Description of industry or industry closest to your product or service
Marketing plan
Financial plan
Production plan
Organizational plan
Operational plan
Summary
Appendices (exhibits)
While it is expected that plan components may vary in length, each should contain detail commensurate with its nature and importance.
Submission Details:
Submit your answers in a 5- to 6-page Microsoft Word document, using APA style.
Name your document: SU_MBA6710_W3_LastName_FirstInitial.doc.
Submit your document to the Submissions Area by the due date assigned. 

On indeed.com, or another job posting website, locate an open position that you could (reasonably) obtain within the next several years. Don’t pick a CEO position that requires 25 years of experience and starts out making $500,000 per year. For this phase, complete the following:
Provide the link to the job posting, so that I can read about the job while grading your assignment.
Provide the annual starting salary, if it is given. If the posting does not have a salary, that is okay. There are websites where you can locate the “average” starting salary for the job, which will also let you sort by state. Provide the source where you located the average salary, and assume that is what you will have.
Provide a short summary of your reasoning behind these choices. Why did you pick this job? Why did you pick this location? Include any other information that you feel is relevant (at least one paragraph).
Decide on a vehicle that you would purchase. Note that if you choose to live somewhere that offers public transportation, you can choose to opt-out of this phase of the assignment. However, again, be REASONABLE! If you live in Williamsburg, KY, you probably aren’t going to choose to not own a vehicle. Also, if you choose to go for public transportation, you have to include an estimate of that cost in your budget when you get to that phase. Taxi fees, bus fares, or a MetroCard is still an expense that you have to account for every month/year. For this section, complete the following:
Provide the link to the car you choose to purchase, or alternatively, provide the link for the pricing estimate for public transit.
Also, include information on whether or not you are trading in a vehicle, and look up the MSRP and trade-in value both for your new vehicle and your trade-in. Based on this information, you will tell me what amount you think you could pay that is lower than the sticker price.
Use the dealership website calculators to estimate your monthly payment for the vehicle. Apply the debt safety ratio rule to this assignment to make sure that you aren’t exceeding 20% of your take-home income, which you should know based on the career and salary that you picked in phase 1.
Provide a short summary of the reasoning behind your choice. Did you go with used or new? Does it come with a warranty? Would you go with a shorter or longer payment period? Did you decide to lease instead of purchase? Were there any specifics on the vehicle that you chose for a certain reason? For example, if you chose to live up north, did you buy something that could travel in snow? If you plan to commute a long distance from work, did you find something with good gas mileage? You might even combine this information with phase three and see how far away the house you purchase will be from your job location. Be as detailed as possible (at least half of a page).
For phase three, you will locate a place to live. You have the option of either renting or purchasing a home. If you decide to purchase a home, you can assume that you have already started building your credit score and saved a REASONABLE amount for a down payment (no more than $10,000).
Use a website such as Zillow to locate a place to live. You can sort on Zillow between rental and homes to purchase.
Use the rule of thumb that your total monthly mortgage payment should not exceed 30% of your gross income. To be more thorough, you can also include your car payment with the rule of thumb that your total debt should not exceed 38% of gross income with mortgage and car payments combined.
Use the mortgage calculator on Zillow (or another website) to list the “estimated” rental or mortgage price for the home you pick.
Locate the exact location of your job from phase one, and the exact location of the home you pick. How many miles are between them?
Provide a summary explaining your thought process on this section, and include any other relevant information
Now that you have a job, a place to live, and transportation sorted out, you will now create a the income statement & monthly budget. The statement format will follow the formats used in chapter 2.
You can include any information you’d like, but you have to explain it. If you want to leave off information for investments, or cable, etc. you can do so. Also, research your answers to this to give real-world estimates for things such as groceries, entertainment, insurance, etc. It doesn’t have to be exact, but it needs to make sense.
Include the summary explaining where you came up with the numbers you used on the statements.

I am using DCF and Ratios. I have already work on the model. I want a writer who specializes in finance to continue the work for me. 

I need help on the project. It is very important to me. If you have any question or need to engage more information, please don’t hesitate to let me know. hi there. Nice to meet you. For the project, I am planning to chose Exxon Mobile ( XOM ) for the analysis. I will download financial statement of XOM and post the excel file here. Thank you in advance

Directions
Imagine that you are the financial manager of a major corporation. The Chief Executive Officer (CEO) has asked you to explain the reasons to consider different types of business combinations and ways to structure them—joint ventures, mergers, strategic alliances, and more. As the financial manager, you will write an email with this explanation. Assume the CEO is not a finance expert.
Specifically, you must address the following rubric criteria:
1. Explain the reasons to consider different types of business combinations.
2. Describe different ways to structure business combinations.
3. Utilize vocabulary and explanations suitable for a non-expert in finance to understand the communication.
What to Submit
Your journal assignment must be a Microsoft Word document of 5–6 paragraphs in length and must address all of the rubric criteria. Your assignment should use at least two sources cited in APA format. Consider using required readings as well as news articles. Any sources used should be less than 60 days old. Using older sources may result in being asked to resubmit your work.

Directions
Place your ratio calculations in the MS Excel table template for Mastercard for 2017 -2019.
Provide the formula used to calculate each ratio in the column to the right of your calculations. For example, for calculating the Gross Margin for a company, you would enter Gross Profit / Sales (gross profit divided by sales).
When calculating values, you should use the SUM function in MS Excel and reference the values directly from the accounting statements provided. Attached you will find an example for PayPal and the calculations for Gross Margin and Operating Margin using MS Excel SUM function.