Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

week 7


Problem Set #7

Attached Files:

·

 Building a Model – Marvel Renovations.xlsx
 (18.835 KB)

Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:

 

Sales

Labor and Raw Materials

May, 2020

$75,000

$80,000

June, 2020

$115,000

$75,000

July, 2020

$145,000

$105,000

August, 2020

$125,000

$85,000

September, 2020

$120,000

$65,000

October, 2020

$95,000

$70,000

November, 2020

$75,000

$30,000

December, 2020

$55,000

$35,000

January, 2021

$45,000

N/A

 

Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the one in which these costs were incurred. Total costs for labor and raw materials are estimated for each month as shown in the table. General and administrative salaries will amount to approximately $25,000 a month; lease payments under long-term lease contracts will be $7,000 a month; depreciation charges will be $8,000 a month; miscellaneous expenses will be $5,000 a month; income tax payments of $30,000 will be due in both September and December; and a progress payment of $95,000 on a new office suite must be paid in October. Cash on hand on July 1 will amount to $70,000, and a minimum cash balance of $30,000 will be maintained throughout the cash budget period.

a. Prepare a monthly cash budget for the last 6 months of 2020.

b. Prepare an estimate of the required financing (or excess funds)—that is, the amount of money Marvel’s Renovations will need to borrow (or will have available to invest)—for each month during that period.

c. Would the cash budget be accurate if inflows came in all during the month, but outflows were bunched early in the month?

d. If its customers began to pay late, this would slow down collections and thus increase the required loan amount.  Also, if sales dropped off, this would have an effect on the required loan.  Do a sensitivity analysis that shows the effects of these two factors on the max loan requirement.  Assume the purchases of labor and raw material also vary by the sales adjustment factor.

Submit your answers in a Word document.



Research Paper -Individual Submission

Attached Files:

·

 Week 7 Research Paper – Research Topic List .docx
 
Week 7 Research Paper – Research Topic List .docx – Alternative Formats (19.201 KB)

Research Paper: This is a graduate course and students will be expected to research and write papers 
summarizing in their own words what they have found on current topics from the weekly readings. Research is a theoretical review of relevant literature and application of findings in the literature to a topic related to a specific industry, field, or business problem.

 

The 

research must be conducted using peer-reviewed trade or academic journals
. While Blogs, Wikipedia, encyclopedias, course textbooks, popular magazines, newspaper articles, online websites, etc. are helpful for providing background information, these resources are 
NOT suitable resources for this research assignment.

 


Assignment Requirements:

i. Choose a research topic
from the chapter readings or from the list provided by your professor.

ii. Research/find a minimum at least four (4), preferably five (5) or more, different peer-reviewed articles on your topic from the University of the Cumberlands Library online business database. The article(s) must be relevant and from a peer-reviewed source. While you may use relevant articles from any time frame, current/published within the last five (5) years are preferred. Using literature that is irrelevant or unrelated to the chosen topic will result in a point reduction.

iii. Write a four (4) to five (5) page double spaced paper in APA format discussing the findings on your specific topic in your own words.
 Note – paper length does not include cover page, abstract, or references page(s).

iv.
Structure your paper as follows:

a.
Cover page

b.
Overview describing the importance of the research topic to current business and professional practice in your own words.

c.
Purpose of Research should reflect  the potential benefit of the topic to the current business and professional practice and the larger body of research.

d.
Review of the Literature summarized in your own words. Note that this should not be a “copy and paste” of literature content, nor should this section be substantially filled with direct quotes from the article. A literature review is a summary of the major points and findings of each of the selected articles (with appropriate citations). Direct quotations should be used sparingly. Normally, this will be the largest section of your paper (this is not a requirement; just a general observation).

e.
Practical Application of the literature. Describe how your findings from the relevant research literature can shape, inform, and improve current business and professional practice related to your chosen topic.

f.
Conclusion in your own words

g.
References formatted according to APA style requirements

v. Attach your paper to the Discussion board by the Thursday due date.

vi. Read and respond to at least four (4) other student postings by the Sunday due date.

Week Seven: Research Paper – List of potential research topics

To complete the Article Research Paper due in Week 7, please select a topic from the list provided below or from the chapter readings.

· Financial Markets

· Capital Allocation Process

· Debt, Equity and Derivative

· Securitization

· Mortgage-backed securities

· Federal Reserve Policy

· Investment Fund

· Regulation of Financial Institution

· U.S. Stock Market

· Financial Statements & Reports

· Working Capital

· Sarbanes-Oxley and Financial Fraud

· Performance Evaluation

· Return on invested capital

· The Federal Income Tax System

· Corporate Capital Gains

· Financial Analysis & Financial Ratios

· Common Size Analysis & Trend Analysis

· Comparative Ratios & Benchmarking

· Time Value of Money

· Perpetuities & Annuities

· What loans really cost

· The Great Recession of 2007

· Bonds Market

· Credit Default Swaps

· Sinking Funds

· Determinants of Market interest rates

· Bond Ratings

· The term structure of interest rates

· Bankruptcy & Reorganization

· Financing with Junk Bonds

· Investment Returns & Risk

· What does investment risk mean?

· Risk in a portfolio context

· Diversification and Multi-Stock Portfolios

· Capital Asset Principal Model

· Bernie Madoff Story

· The Efficient Markets Hypothesis

· The Fama-French Three-Factor Model

· Corporate Valuation and Stock Prices

· Do stock values affect long term or short term cash flows?

· Why are stock prices so volatile?

· Financial options

· Employee Stock Options

· The Black-Scholes Option Price Model (OPM)

· Taxes and Stock Options

· The Weight Average Cost of Capital

· Corporate Valuation and the Cost of Capital

· Global Variation in the cost of capital

· Managerial Issues and the Cost of Capital

· Capital Budgeting

· Capital Rationing

· Risk Analysis in Capital budgeting

· Risk Analysis

· Project Valuation

· The cash flow effect of asset purchases and Depreciation

· Externalities

· Tax Depreciation

· Financial Planning

· Implementing the Target Capital Structure

· Economies of Scale

· Conflicts between stockholders & Creditors

· Conflicts between managers & shareholders

· Monitoring and Discipline by the Board of Directors

· Charter provisions and by laws that effect the likelihood of hostile takeovers

· Using compensation to align managerial and shareholder interests

· Capital Structure and Internal Control systems

· Environmental Factors outside a firm’s control

· Stock Repurchase

· Tax Effect Theory

· Dividend Irrelevance Theory

· Empirical Evidence on Distribution Policies

· The impact of Distribution on Intrinsic Value

· The pros and cons of dividends and repurchases

· Capital structure

· Business risk and financial risk

· Capital structure theory

· Using the Black-Sholes Option Pricing Model to value equity

· Managing the maturity structure of Debt

· Supply Chain Management

· Credit Policy

· The cost of trade credit

· Revolving credit agreement

· Multinational versus domestic Financial Management

· Exchange rates

· Exchange rates & international trade

· The international monetary system and exchange rate policies

· Purchasing power parity

· International Money and Capital Markets

image1.gif

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

Deliverable 2 – Develop an Advocacy Report

  Scenario You are the director of community affairs for the health lobby organization, Pathways to a Healthy America. In 2010, President Barack Obama signed the Affordable Care Act into law. As a result, millions of Americans who were previously uninsured gained access to the healthcare system. One of the

D7

Research and find any free organizational culture quiz. Some free quiz sites are provided below, but feel free to search and use your own quiz. · Culture QuizLinks to an external site. · What’s Your Organizational Culture? Links to an external site. Take the quiz and then copy/paste your results into

W2

Team Effectiveness in the Workplace Instructions Teams and their use in organizations seem to have varying degrees of success. We all know what a successful athletic team looks like. Managers often times try to translate that structure and in turn success back to the organization by organizing their employees in

4.2222

  Watch the “Lack of Commitment” video. on Youtube Post your response in a conversational tone and narrative form. When there is not a natural consensus- can you disagree as individuals and commit as a team? What Scriptures or other faith-based references support this concept? 

Virtual Teams

 What are some challenges managers face when communicating with virtual teams? 

ADD TO RESUME

KRYSTEL BERGHER PROFILE Accomplished Customer Service Expert committed to the delivery of quality service. Professional and Ethical. Seeking to assist or help a new customer service department in creating and achieving the much-needed customer service goals. CONTACT ADDRESS: 15851 Southwest 139th Place, Miami FL 33177. PHONE: 305-992-6010 EMAIL: [email protected] om

Economic & Marketing

Homework  Sustainability, Social Impact, and the Bottom Line Think about a product or service you recently purchased that originated from a company whose Mission includes a focus on sustainability or social impact. In other words, a company that “does well by doing good.“ Then read and reply to each of the prompts

BUS 3301 Unit VII Q12

Business Law BUS 3301 VII Question 12 The principal agent relationship, the employer-employee relationship, and the employer-independent contractor relationship are three types of agency relationships commonly found in business settings. Why is it important for business professionals to know what type of agency relationship they are forming?   Your response must

ITC_3303 E

Information Systems Management ITC 3301 Unit VII Essay In this final assignment, you will develop a paper that reviews some of the main topics covered in the course. Compose an essay to address the following: · Identify the components of an information system using the five-component framework and provide a

BUS 3301 Unit VII Q11

Business Law BUS 3301 VII Question 11 Have you ever bought something, paid for it, and arranged to have it delivered to you at a later date? That is a fairly typical transaction, and, under the Uniform Commercial Code (UCC), a delivery contract is created. However, it is a little

case

  1. How did Apple’s introduction of the IPhone in 2007 lead to its success over its main competitors? Think about which industries it has disrupted and how. 2. What are some the challenges facing Apple today? What should Apple do to address them? Be Specific.

Enviromental Analysis

Creating a mission vision instruction and an organizational chart Creating an Organization Chart BUS 100 Introduction to Business Organization Chart Instructions Organization Chart Create a hierarchy (think inverted tree) with the top decision maker at the top. Identify the different levels of management down to non-management roles. Determine if you

Strategic Financial Management

Project Overview: In the previous project part, you developed a flexible (flex) budget based on an unforeseen expense provided to you by your professor. For this project part, you will take things one step further by determining ways to reduce spending in different areas or aspects of your business.  Using

Strategic Financial Management

Project Overview: In the previous project part, you developed a flexible (flex) budget based on an unforeseen expense provided to you by your professor. For this project part, you will take things one step further by determining ways to reduce spending in different areas or aspects of your business.  Using

Please see attached – need in 24 hrs

Select 1 well-known business you would like to research and use as the basis for developing a marketing campaign. Refer to the following resources, as needed, for assistance selecting a business and locating information about it: · Marketing professional organizations, such as  4 A’s  website or  American Marketing Association  website  

CJ 2500 MOD 6 FINAL

INSTRUTIONS ATTACHED TOPIC TO DISCUSS How gps tracking units placed on cars can be obtained by law enforcement consistent with the 4th amendment and how such devices can help criminal investigations? Remember there must be critical analysis from you I the paper and not just a book report. Overview: A

week 3 pending

pfa TASK 1: By Tuesday Evening Reflection and Discussion Forum Week 3 Assigned Readings: Chapter 8. Understanding Markets and Industry Changes. Chapter 9. Market Structure and Long-Run Equilibrium. Chapter 10. Strategy: The Quest to Keep Profit from Eroding. Initial Postings: Read and reflect on the assigned readings for the week.