Category Archives: Research Papers
HR analytics excel
In this assignment you are required to:
- Document the solutions as set out in the assignment requirements in a clear manner.
- All visualizations and analytics are based on the HR excel dataset attached.
- Submit your assignment documentation online via Blackboard
Exploratory Data Analysis using SAS Studio Analytics
Requirements:
Conduct an Exploratory Data Analysis for the given dataset using SAS Studio. You may include the following in your analysis.
- Derive a suitable visualization for the corresponding HR dataset. You may analyse the data using any five (5) types of graphs in SAS Studio. Write a short analysis based on the outcome of the graph. [15 marks]
Problem solving- Calculations & Problem solving
3.1 Coupling coordination degree model
Coupling coordination degree model is one that refers to that which after, the whole is divided into multiple subsystems, and the overall function and role are inseparable from the coordination degree between the subsystems. Only when the degree of coordination between the subsystems is high can the overall effect be maximized. The higher the degree of coupling, the greater the degree of interaction between systems, and vice versa.
The regular formula for measuring the coupling coordination degree is as follows:
(3.1.1)
Where Ui denotes the development level of system I in which the value is between 0 and 1.
The state of interaction between the Gulf of Guinea Port and the hinterland economy can be defined as a coupling coordination degree model. This interaction between the two systems can be reflected in a close relationship. The excellent development of the hinterland economy can support the development of the port via sufficient investments and efficient demands for transportation. As the foreign trade in the hinterland, the excellent development of port can also provide employment opportunities and drive the growth of the economy of the hinterland. For the evaluation of the coordination development relationship of the port of Guinea and the economic system of the hinterland, the following model can be established:
(3.1.2)
Where: and
C represents the coupling degree function of the Gulf of Guinea Port and its hinterland economic system, and U1 and U2 represent the development level of the Gulf of Guinea Port and its hinterland financial system. bk and ds are the weights of indicators of the two subsystems, and yk and ύs are the standardized values of the hands of subsystems of the coupling coordination degree model. However, K and S are the numbers of indicators of the two subsystems. The model also allows us to measure the association degree between the subsystems. The significant shortcoming in this regard is that when both systems’ development levels are low, there are still chances of the coupling degree reaching a more substantial value. The coupling coordination degree is adopted to measure the degree of collaborative development between the two systems to establish the model successfully and avoid shortcomings.
(3.1.3)
(3.1.4)
Here D represents the coupling coordination degree, and T represents the comprehensive coordination degree between the Gulf of Guinea Port and its hinterland economic system. The degree is valued between 0 and 1. If the value is closer to zero, it indicates a lower level of collaborative development of the two subsystems, while the weight closer to 1 indicates a higher level of joint development.
Figures: (3.1a) Basic types of coupling coordination models
(3.1b) Improved coupling coordination degree model
The uniform distribution function method can finally be adopted to bring coordination development level between the subsystems. It is divided into three stages and ten types based on values as showcased on table 3.1 below:
Table 3.1 Classification criterion for identifying the coordinated development relationship
Stage | Range | Coordination states | Range |
Stage of disorder |
D ϵ (0, 0.4) |
Serious imbalance
Disorders (severe) Moderate disorders Mild disorders |
(0, 0.1)
(0.1, 0.2) (0.2, 0.3) (0.3, 0.4) |
Stage of transition | D ϵ (0.4, 0.6) | On the verge of disorder
Mild coordination Primary coordination |
(0.4, 0.5)
(0.5, 0.6) (0.6, 0.7) |
Stage of coordinated development | D ϵ (0.6, 1) | Intermediate coordinate
Good coordination Perfect coordination |
(0.7, 0.8)
(0.8, 0.9) (0.9, 1) |
Coordination and collaboration activities between ports (exemplified on Figure 3.2) aim to help a port authority legitimize its expansion by taking on a more hands-on role as a landlord, which is good for everyone involved. Investments in enlisting supply chain participants at the port and in the hinterland are primarily motivating the development of coordination mechanisms in order to accommodate rising traffic volumes. Environmental concerns, a lack of available land for port growth, and monopolistic competition among terminal operators all point to a need for a more proactive involvement on the part of port authorities. With the use of integrated methods and collaboration strategies with other port authorities, coordination plans have been developed by port authorities.
Figure 3.2 Port Coordination Scheme
According to Martnez-Zarzoso and Hoffmann (2007), if economic measures were implemented to promote and expand port connectivity, it would cut the costs of transportation and, as a result, increase international trade in commodities. In particular, they discovered that a one percent improvement in connectivity in Latin American countries would lower the costs of transportation by one point ninety percent and increase commerce by one point thirty-three percent.
Figure 3.3 Gulf of Guinea Port Geographical Location
3.1 Coupling coordination degree model
Coupling coordination degree model is one that refers to that which after, the whole is divided into multiple subsystems, and the overall function and role are inseparable from the coordination degree between the subsystems. Only when the degree of coordination between the subsystems is high can the overall effect be maximized. The higher the degree of coupling, the greater the degree of interaction between systems, and vice versa.
The regular formula for measuring the coupling coordination degree is as follows:
(3.1.1)
Where Ui denotes the development level of system I in which the value is between 0 and 1.
The state of interaction between the Gulf of Guinea Port and the hinterland economy can be defined as a coupling coordination degree model. This interaction between the two systems can be reflected in a close relationship. The excellent development of the hinterland economy can support the development of the port via sufficient investments and efficient demands for transportation. As the foreign trade in the hinterland, the excellent development of port can also provide employment opportunities and drive the growth of the economy of the hinterland. For the evaluation of the coordination development relationship of the port of Guinea and the economic system of the hinterland, the following model can be established:
(3.1.2)
Where: and
C represents the coupling degree function of the Gulf of Guinea Port and its hinterland economic system, and U1 and U2 represent the development level of the Gulf of Guinea Port and its hinterland financial system. bk and ds are the weights of indicators of the two subsystems, and yk and ύs are the standardized values of the hands of subsystems of the coupling coordination degree model. However, K and S are the numbers of indicators of the two subsystems. The model also allows us to measure the association degree between the subsystems. The significant shortcoming in this regard is that when both systems’ development levels are low, there are still chances of the coupling degree reaching a more substantial value. The coupling coordination degree is adopted to measure the degree of collaborative development between the two systems to establish the model successfully and avoid shortcomings.
(3.1.3)
(3.1.4)
Here D represents the coupling coordination degree, and T represents the comprehensive coordination degree between the Gulf of Guinea Port and its hinterland economic system. The degree is valued between 0 and 1. If the value is closer to zero, it indicates a lower level of collaborative development of the two subsystems, while the weight closer to 1 indicates a higher level of joint development.
Figures: (3.1a) Basic types of coupling coordination models
(3.1b) Improved coupling coordination degree model
The uniform distribution function method can finally be adopted to bring coordination development level between the subsystems. It is divided into three stages and ten types based on values as showcased on table 3.1 below:
Table 3.1 Classification criterion for identifying the coordinated development relationship
Stage | Range | Coordination states | Range |
Stage of disorder |
D ϵ (0, 0.4) |
Serious imbalance
Disorders (severe) Moderate disorders Mild disorders |
(0, 0.1)
(0.1, 0.2) (0.2, 0.3) (0.3, 0.4) |
Stage of transition | D ϵ (0.4, 0.6) | On the verge of disorder
Mild coordination Primary coordination |
(0.4, 0.5)
(0.5, 0.6) (0.6, 0.7) |
Stage of coordinated development | D ϵ (0.6, 1) | Intermediate coordinate
Good coordination Perfect coordination |
(0.7, 0.8)
(0.8, 0.9) (0.9, 1) |
Coordination and collaboration activities between ports (exemplified on Figure 3.2) aim to help a port authority legitimize its expansion by taking on a more hands-on role as a landlord, which is good for everyone involved. Investments in enlisting supply chain participants at the port and in the hinterland are primarily motivating the development of coordination mechanisms in order to accommodate rising traffic volumes. Environmental concerns, a lack of available land for port growth, and monopolistic competition among terminal operators all point to a need for a more proactive involvement on the part of port authorities. With the use of integrated methods and collaboration strategies with other port authorities, coordination plans have been developed by port authorities.
Figure 3.2 Port Coordination Scheme
According to Martnez-Zarzoso and Hoffmann (2007), if economic measures were implemented to promote and expand port connectivity, it would cut the costs of transportation and, as a result, increase international trade in commodities. In particular, they discovered that a one percent improvement in connectivity in Latin American countries would lower the costs of transportation by one point ninety percent and increase commerce by one point thirty-three percent.
Figure 3.3 Gulf of Guinea Port Geographical Location
Financial Markets and Institutions
PART 1: ACADEMIC INTEGRITY MODULE (3 marks)
Complete the Academic integrity micro-credential: https://www.rmit.edu.au/study-with-us/levels-of-study/short-courses/academic-integrity-awareness
You will receive a certificate when you complete the micro-credential and Submit the certificate under submission point 2.
PART 2: SCENARIO ANALYSIS (47 marks)
Please submit your final assessment under submission point 3
You are a financial advisor who regularly educates new clients about how market and economic systems work to take the mystery and fear out of investing. You have found that when clients understand how things work behind the scenes, they feel more confident in continuing to invest throughout their lives, regardless of the doom and gloom that they may see or hear in the news. In this report, you are asked to address questions that your new client Leo has and help him to have a better understanding of financial markets.
1. Understanding Different Asset Classes
(TOTAL 15 MARKS)
a) There are many ways to invest money. Suppose that Joe wonders what investment options he can choose from. In the following table there are different assets, chose three of them and fill in related columns. You should also provide an example for each of them.
(6 marks)
Asset |
Characteristics |
Risk |
Potential Returns |
Example |
Commodity |
||||
Shares |
||||
Bonds |
||||
Cash investment |
||||
Derivatives |
b) Australia and New Zealand Banking Group Limited (ANZ) offers a bill facility to corporate clients. The bank website explains the terms and conditions of Bills of Exchange. https://www.anz.com/documents/FXOnline/Bbills123.pdf
Use a diagram to describe the structure of a bank bill. In your explanation, clearly distinguish the roles of the parties associated with the bill issue.
(5 marks)
c) In June 2020, Singapore Airlines Limited undertook a renounceable rights issue of new ordinary shares in the capital of the company and mandatory convertible bonds to entitled shareholders.
· Explain the renounceable rights issue of ordinary shares and discuss the advantages and disadvantages. (2 marks)
· Explain to Leo what is convertible bonds and why would Singapore Airlines undertake mandatory convertible bonds to entitled shareholders?
(2 marks)
2. Central Banks, Monetary Policy and Interest Rates
(TOTAL 14 MARKS)
- Market participants, including financial institutions, fund managers and corporations, must understand monetary policy setting impacts on economic activity and the business cycle. A central bank will typically implement monetary policy settings in order to achieve certain economic outcomes over a business cycle. Choose two countries from the list below, describe the intermediate target for monetary policy, and explain the implementation process of the monetary policy in the two countries you selected. Give examples of different economic indicators that may give an insight into the future stages of a business cycle.
- the United States
- Australia
- Singapore
- China
- Russia
- New Zealand
- marks)
- In 7th Sep, for the fifth time this year, the Reserve Bank of Australia (RBA) increased the cash rate by 0.5%. The current cash rate is 2.35%. Explain to Leo how the monetary policy transmits to the overall economy. Explain how the high cash rate affects imports and exports in Australia and provide an example for your reason.
(4 marks)
- Obtain weekly data from Refinitiv Eikon and plot the interest rates (bid and ask mid- rate) on 2-year commonwealth government bond (AU2Y-TBOND) and 10 year commonwealth government bond (au 10Y-TBOND) from June 2020. Determine the shape of the yield curve by using one of the interest rate theories you know and share your opinion on whether the Australian economy is heading for a boom or for a recession. Explain your choice.
(4 marks)
- Derivative Securities
(TOTAL 8 MARKS)
- Leo knows that the primary purpose of a futures contract is the management of risk exposures. Provide more explanation about its key features and also with an example explain pros and cons of futures contacts.
(2 marks)
- Leo bought Amazon shares at 140$ in August and after a couple of weeks it dropped to 45$ in Mid of September, so based on this risky and high volatility situation of stock markets, he is looking to control his risk by the option contract. Leo needs your advice on using options contracts. The following table shows a list of options for you to choose from. Further, suppose that each contract contains 100 shares
Strike | Call premium | Moneyness | Put premium | Moneyness |
$125 | $10.05 | $0.01 | ||
$130 | $3.65 | $0.05 | ||
$136 | $0.7 | $0.99 | ||
$145 | $0.05 | $10.48 |
- Please specify the moneyness of the above options. Are they in the money, at the money, or out of the money?
(3 marks)
- Explain the type of risk that Leo is facing and which option is your suggestion to control his risk, provide your reason and explain it.
(3 marks)
- Fund Management
(TOTAL 10 MARKS)
- Managed funds are often categorised by the type of investments purchased by the fund. These include capital stable funds, balanced growth funds and managed capital growth funds. For each of these funds, discuss the types of investments the fund might accumulate and explain the purpose of the investment strategies. If Leo is identified as a risk-averse investor, which type of fund would you recommend Leo to consider investing in?
(4 marks)
- The risk free rate in Australia in Jun 2022 was 3.37%. Based on the following information for three different funds A, B and C in Australia. Calculate the Coefficient of variation, Sharpe and Jensen Indices of performance for these funds and interpret the results.
(4 marks)
Fund | Average return (%) | Variance(%) | Beta |
Market
Fund A Fund B Fund C |
6.95
9.50 8.65 7.90 |
–
102.21 179.16 67.73 |
–
0.88 1.35 1.05 |
- Obtain information on the following two funds:
- Colonial First State Developing Companies Fund
- Vanguard Australian Shares High Yield Fund
Compare the risks to investors presented by each of these funds and identify the types of investors that would favour these funds.
(2 marks)
(TOTAL 15+14+8+10 = 47 MARKS)
Capital Management Presentation
For a health care organization to survive and grow, it requires capital. Effective capital management is vital for the business to function, especially in health care sectors that exist with such narrow profit margins. Your business operations skill is important to be able to identify risks associated with various financing options for capital projects that fund growth, purchase equipment, and build new facilities.
Preparing for the Assignment
Create this assignment using Microsoft® PowerPoint®.
Assignment Directions
Create a 12- to 15-slide presentation with detailed speaker notes in which you:
-150 words or more for speaker notes and please make them flow. Not just bullet points.
-13 slides is appropriate not including title page.
- Evaluate effective working capital-management techniques.
- Evaluate alternative capital projects.
- Analyze risks associated with capital projects.
- Describe the decision-making factors in lease versus buy.
- Describe the effect of financing strategies on the cost of capital.
- Describe the benefits and risks of debt financing.
Incorporate appropriate use of images or other multimedia in your presentation.
Cite any sources, images, and multimedia included in your presentation.
COMMERCE 4FE3:Options and Futures
Please show all your works and use 4 decimal points in your answers.
All interest rates herein are expressed with continuous compounding.
In case you need to make assumptions, please clearly state them. Only reasonable
assumptions are acceptable. Assumptions that violate finance principles are not to be
made.
For numerical questions, simply calculating the numbers out will not be sufficient.
Please also provide me with the reasons for your calculations. Correct thinking
processes are much more important than correct numbers. Therefore, regardless of
whether or not your numbers are correct, no marks will be given if (a) no explanation
of your calculations is provided; or (b) the explanation provided is incorrect. On the
other hand, even if your numbers are incorrect, partial marks will be given if your
thinking process is correct.
Please note that marks can only be given based on what you write. Therefore, I request
that you attempt to convey your ideas to me as clearly as possible. I will not make a
guess as to what you intend to mean if you do not make it obvious and clear.
When your answers involve taking positions in securities or lending/borrowing, please
mention all the relevant details such as the timing of the transactions, the side of the
contracts (e.g., long or short forward), the length of the contracts (e.g., 6-month
futures), the exercise prices (in case of options) and the interest rates (in case of lending
or borrowing).
2
1) (3 points) Consider an index-linked note that has a maturity of 3 years. Suppose you
buy this note today (say, with a principal of $100). After three years, you will get the
principal back plus interest at the rate equal to the percentage increase in the TSX 60
stock index over the three-year period up to 30%. If the index declines over the threeyear period, the interest will be zero.
As an example, suppose that the TSX 60 index today is 800. The percentage return on
the note will be as follows:
– If after 3 years, the index is ≤ 800, the percentage return on the note will be
zero (i.e., you will only get the principal back).
– If after 3 years, the index is between 800 and 1,040 (i.e., an increase of up
to 30% over the three-year period), the percentage return on the note will
be equal to the percentage increase in the index.
– If after 3 years, the index is > 1,040 (i.e., an increase of > 30% over the
three-year period), the percentage return on the note will be 30%.
Please explain how you can replicate the payoffs of this note.
2) (3 points) You want to short a 6-month forward contract on a stock. You contacted
your bank and were offered a forward price of $39.85 [Note: This forward price is
available only to customers who want to take a short position. Customers who want to
take a long position will get a different quote.]. You also observe the following
information:
– Current price of the stock = $40
– Expected dividend on the stock = $0.50, payable 3 months from now
– Your spot 3-month lending rate = 2.50% p.a. [i.e., This is the rate that you will
get if you lend money for 3 months, starting now.]
– Your spot 3-month borrowing rate = 4.00% p.a. [i.e., This is the rate that you
will have to pay if you borrow money for 3 months, starting now.]
– Your transaction cost in buying one stock in the spot market = $0.10, payable
at the time of the transaction.
– Your transaction cost in short selling one stock in the spot market = $0.20,
payable at the time of the transaction (This already includes the transaction cost
for closing out the short-sale transaction).
What is the minimum 6-month spot lending rate that you need to get in order for you
to reject the bank’s offer?
3
3) (3 points) A friend of yours believes that Apple stock is now overvalued. As a result,
she expects that their stock price, now at $140 per share, will not go up any further.
She is prepared to back up her conviction by offering you the following bet. If in
exactly one year from now Apple stock price is higher than $140/share, she will give
you two hundred times the amount of the difference (e.g., suppose the price in one year
is $145 per share, you will get $1,000). On the other hand, if the price in one year ends
up below $140/share, you will have to give her two hundred times the amount of the
difference (e.g., suppose the price in one year is $137 per share, you will have to give
her $600). Suppose that the expected return on Apple stock is 10% p.a. Suppose also
that the current risk-free rate is 2% p.a. and Apple does not plan to pay dividends in the
next year. What is the value of this bet to you?
Hint: Write out the payoff function of this bet. What does it look like to you?
4) (3 points) Your boss is offering you a choice between two bonus schemes. Under the
first scheme, you will receive a sum of $20,000 per year for three years, with the first
payment starting one year from now. Under the second scheme, you will receive 100
shares of your company’s stocks per year for three years, with the first payment starting
one year from now.
You observe the following information:
Current spot price of your company’s stock: $190/share
Spot interest rate (for both lending and borrowing): 4% p.a. for all terms
Continuous dividend yield on your company’s stock: 1% p.a.
Which bonus scheme will you choose?
Hint: The stock scheme is risky because you do not know
Laplace Method, Approximate Bayesian Inference
Please answer the following questions and provide references for your answers.
Question 1
What is approximate Bayesian inference and give at least three examples of approximate inferential frameworks.
Question 2
Explain what is a Latent Gaussian Model (LGM).
Question 3
Explain what is a Gaussian Markov Random field (GMRF) and give an example thereof.
Question 4
Explain the Laplace method as an approximate inference tool.
MGT425 – Interactive Activity
Learning Outcomes:
- Find some structured ways of dealing with complex managerial decision problems.
- Explain simple decision models and management science ideas that provide powerful and (often surprising) qualitative insight about large spectrum of managerial problems.
- Demonstrate the tools for deciding when and which decision models to use for specific problems.
- Build an understanding of the kind of problems that is tackled using spreadsheet modeling and decision analysis.
8.2 Action Required:
Read the following chapter of your Textbook.
Chapter 8: Non-Linear Optimization
8.3 Test your Knowledge (Question):
- Explain the various types of constraints.
- Describe the Portfolio Optimization Model.
8.4 Instructions
- Answer both questions in test your knowledge section.
- Post your answer in the discussion board using the discussion link below (Week 8: Interactive learning Discussion)
FNCE371 Applications in Corporate Finance
Cash Management
Ms. Amanda Truly is the new CFO of Mind and Body, Inc., which produces popular yoga and Pilates videos. Ms. Truly is concerned about the company’s cash flow management, and would like to get a better “feel” for the way cash flows are managed at Mind and Body, Inc. The CEO of the company, Mr. Lawrence Jackson, is worried about the company’s cash situation. Although the company has consistently produced positive net income, the level of its short-term borrowing is worrisome. Mr. Jackson would like Ms. Truly to construct a cash budget for next year so that they can devise a short-term financial policy that would effectively suit the company’s cash flows.
To this end, Mr. Jackson has provided Ms. Truly with the company’s most recent Statement of Comprehensive Income, Statement of Financial Position, and Cash Budget, and the following disparate information:
- Purchases from suppliers = 70% of predicted sales for the next month
- Accounts payable period = 30 days
- Wages and other expenses = 20% of predicted sales
- Capital expenditures (computer system purchase) in June = $500,000
- Long-term debt interest expense = $50,000
- Dividends = $30,000 per quarter
- Minimum cash balance = $200,000
- Short-term cost of borrowing = 13% APR, compounded monthly
- Long-term cost of borrowing = 10% APR, compounded monthly
- Income taxes from last year’s income will be paid monthly in this year
- Interest expense on accumulated short-term expense must be paid in the following month
- Customer payments: 50% in the month of sales, 30% pay in the month after sales, and 20% two months after sales
- Bad debt = ~ 2% if customers have not made payment after 60 days
Table 1: Last Year’s Statement of Comprehensive Income | |
Sales | $10,944,250 |
Cost of goods sold | 7,660,975 |
Wages and other expenses | 2,188,850 |
Earnings before depreciation, interest, and taxes | 1,094,425 |
Depreciation | 100,000 |
Earnings before interest and taxes | 994,425 |
Interest expense | 603,760 |
Taxable income | 390,665 |
Taxes | 140,640 |
Net income | 250,025 |
Dividends | 120,000 |
Additions to retained earnings | 130,025 |
Table 2: Last Year’s Statement of Financial Position | ||||
Cash | $200,000 | Accounts payable | 140,000 | |
Inventory | 140,000 | Notes payable | 41,520 | |
Accounts receivable | 792,080 | Current liabilities | 181,520 | |
Current assets | 1,132,080 | |||
Long-term debt | 6,000,000 | |||
Common stock | 2,500,000 | |||
Net fixed assets | 9,004,814 | Retained earnings | 1,455,374 | |
Total owners’ equity | 3,955,374 | |||
Total assets | 10,136,894 | Total liabilities & owners’ equity | 10,136,894 |
Table 3: Cash Budget
Cash collections: |
||||||
January | February | March | April | May | June | |
Sales | 185,000 | 370,000 | 740,000 | 2,035,000 | 203,500 | 407,000 |
Month 0 collections | 92,500 | 185,000 | 370,000 | 1,017,500 | 101,750 | 203,500 |
Month -1 collections | 540,000 | 55,500 | 111,000 | 222,000 | 610,500 | 61,050 |
Month -2 collections | 172,872 | 352,800 | 36,260 | 72,520 | 145,040 | 398,860 |
Total collections | 805,372 | 593,300 | 517,260 | 1,312,020 | 857,290 | 663,410 |
Beginning accounts receivable | 1,076,400 | 452,500 | 222,000 | 444,000 | 1,165,500 | 508,750 |
Sales | 185,000 | 370,000 | 740,000 | 2,035,000 | 203,500 | 407,000 |
Cash collections | 805,372 | 593,300 | 517,260 | 1,312,020 | 857,290 | 663,410 |
Ending accounts receivable | 452,500 | 222,000 | 444,000 | 1,165,500 | 508,750 | 244,200 |
Cash disbursements: | ||||||
January | February | March | April | May | June | |
Beginning accounts payable | 129,500 | 259,000 | 518,000 | 1,424,500 | 142,450 | 284,900 |
Purchases | 259,000 | 518,000 | 1,424,500 | 142,450 | 284,900 | 466,200 |
Payment of accounts Payable | 129,500 | 259,000 | 518,000 | 1,424,500 | 142,450 | 284,900 |
Ending accounts payable | 259,000 | 518,000 | 1,424,500 | 142,450 | 284,900 | 466,200 |
|
||||||
Payment of accounts payable | 129,500 | 259,000 | 518,000 | 1,424,500 | 142,450 | 284,900 |
Wages and other expenses | 37,000 | 74,000 | 148,000 | 407,000 | 40,700 | 81,400 |
Taxes | 20,833 | 20,833 | 20,833 | 20,833 | 20,833 | 20,833 |
Capital expense | 0 | 0 | 0 | 0 | 0 | 0 |
ST interest expense | 400 | 0 | 0 | 0 | 897 | 0 |
LT interest expense | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
Dividends | 0 | 0 | 30,000 | 0 | 0 | 30,000 |
Cash disbursements | 237,733 | 403,833 | 766,833 | 1,902,333 | 254,880 | 467,133 |
Cash collections | 805,372 | 593,300 | 517,260 | 1,312,020 | 857,290 | 663,410 |
Cash disbursements | 237,733 | 403,833 | 766,833 | 1,902,333 | 254,880 | 467,133 |
Net cash inflow | 567,639 | 189,467 | –249,573 | –590,313 | 602,410 | 196,277 |
Cash Budget: | ||||||
January | February | March | April | May | June | |
Beginning cash balance | 200,000 | 767,639 | 957,105 | 707,532 | 200,000 | 719,629 |
Net cash inflow | 567,639 | 189,467 | –249,573 | –590,313 | 602,410 | 196,277 |
Ending cash balance | 767,639 | 957,105 | 707,532 | 117,219 | 802,410 | 915,905 |
Minimum cash balance | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 |
Surplus/deficit | 567,639 | 757,105 | 507,532 | –82,781 | 602,410 | 715,905 |
Short-term borrowing | 0 | 0 | 0 | 82,781 | 0 | 0 |
Repayment of ST debt | 0 | 0 | 0 | 0 | 82,781 | 0 |
Cumulative ST debt | 0 | 0 | 0 | 82,781 | 0 | 0 |
ST interest expense | 0 | 0 | 0 | 897 | 0 | 0 |
Table 3: Cash Budget (Cont.)
Cash collections: |
|||||||||||||
July | August | September | October | November | December | ||||||||
Sales | 666,000 | 2,442,000 | 305,250 | 610,500 | 980,000 | 2,000,000 | |||||||
Month 0 collections | 333,000 | 1,221,000 | 152,625 | 305,250 | 490,000 | 1,000,000 | |||||||
Month -1 collections | 122,100 | 199,800 | 732,600 | 91,575 | 183,150 | 294,000 | |||||||
Month -2 collections | 39,886 | 79,772 | 130,536 | 478,632 | 59,829 | 119,658 | |||||||
Total collections | 494,986 | 1,500,572 | 1,015,761 | 875,457 | 732,979 | 1,413,658 | |||||||
Beginning accounts receivable | 244,200 | 414,400 | 1,354,200 | 641,025 | 366,300 | 612,100 | |||||||
Sales | 666,000 | 2,442,000 | 305,250 | 610,500 | 980,000 | 2,000,000 | |||||||
Cash collections | 494,986 | 1,500,572 | 1,015,761 | 875,457 | 732,979 | 1,413,658 | |||||||
Ending accounts receivable | 414,400 | 1,354,200 | 641,025 | 366,300 | 612,100 | 1,196,000 | |||||||
Cash disbursements: | |||||||||||||
July | August | September | October | November | December | ||||||||
Beginning accounts payable | 466,200 | 1,709,400 | 213,675 | 427,350 | 686,000 | 1,400,000 | |||||||
Purchases | 1,709,400 | 213,675 | 427,350 | 686,000 | 1,400,000 | 140,000 | |||||||
Payment of accounts payable | 466,200 | 1,709,400 | 213,675 | 427,350 | 686,000 | 1,400,000 | |||||||
Ending accounts payable | 1,709,400 | 213,675 | 427,350 | 686,000 | 1,400,000 | 140,000 | |||||||
Payment of accounts payable | 466,200 | 1,709,400 | 213,675 | 427,350 | 686,000 | 1,400,000 | |||||||
Wages and other expenses | 133,200 | 488,400 | 61,050 | 122,100 | 196,000 | 400,000 | |||||||
Taxes | 20,833 | 20,833 | 20,833 | 20,833 | 20,833 | 20,833 | |||||||
Capital expense | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
ST interest expense | 0 | 0 | 2,464 | 0 | 0 | 0 | |||||||
LT interest expense | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | |||||||
Dividends | 0 | 0 | 30,000 | 0 | 0 | 30,000 | |||||||
Cash disbursements | 670,233 | 2,268,633 | 378,022 | 620,283 | 952,833 | 1,900,833 | |||||||
Cash collections | 494,986 | 1,500,572 | 1,015,761 | 875,457 | 732,979 | 1,413,658 | |||||||
Cash disbursements | 670,233 | 2,268,633 | 378,022 | 620,283 | 952,833 | 1,900,833 | |||||||
Net cash inflow | –175,247 | –768,061 | 637,739 | 255,174 | –219,854 | –487,175 | |||||||
Cash budget: | |||||||||||||
January | February | March | April | May | June | ||||||||
Beginning cash balance | 915,905 | 740,658 | 200,000 | 610,336 | 865,509 | 645,655 | |||||||
Net cash inflow | –175,247 | –768,061 | 637,739 | 255,174 | –219,854 | –487,175 | |||||||
Ending cash balance | 740,658 | –27,403 | 837,739 | 865,509 | 645,655 | 158,480 | |||||||
Minimum cash balance | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | |||||||
Surplus/deficit | 540,658 | –227,403 | 637,739 | 665,509 | 445,655 | –41,520 | |||||||
Short-term borrowing | 0 | 227,403 | 0 | 0 | 0 | 41,520 | |||||||
Repayment of ST debt | 0 | 0 | 227,403 | 0 | 0 | 0 | |||||||
Cumulative ST debt | 0 | 227,403 | 0 | 0 | 0 | 41,520 | |||||||
ST interest expense | 0 | 2,464 | 0 | 0 | 0 | 450 | |||||||
Table 4: Sales Forecasts for next 13 months
January | 200,000 |
February | 400,000 |
March | 800,000 |
April | 2,200,000 |
May | 220,000 |
June | 440,000 |
July | 720,000 |
August | 2,640,000 |
September | 330,000 |
October | 660,000 |
November | 1,080,000 |
December | 3,960,000 |
January | 220,000 |
Mr. Jackson asks Ms. Truly to produce a report on the current state of the company’s cash flows and short-term financing needs for a meeting next week. Ms. Truly wrote down the following tasks that must be completed prior to writing her report:
- Construct the monthly cash collections table.
- Construct the monthly cash disbursements table.
- Calculate the monthly net cash inflow.
- Construct the monthly cash budget.
In the report, Ms. Truly plans to include the cash budget as well as answers to the following questions (just sent in by Mr. Jackson):
- What will be the predicted monthly cash deficits and surpluses, and how much short-term financing will the company need in the coming year? What can be inferred from the pattern of cash deficits and surpluses, and the pattern of requirements for short-term financing?
- Why is depreciation expense (a large amount) not included in the cash budget?
- Evaluate the company’s minimum cash reserve policy. What would happen to the cash budget if we changed the minimum cash reserve to $0? To $5,000? To $50,000? To $500,000? Should the company stick with its $200,000 minimum cash balance?
- The Bank of Scotia is offering to invest the company’s surplus cash at 6% APR compounded semi-annually for a fee of $2,000 per year, payable at the end of the year. Earnings on the investment will be calculated and deposited at the end of each month. Should the company invest with the bank?
- The sales estimates were provided by the sales department. Can we trust these figures? What can be done to overcome the forecasting risk?
Notes
- Jackson has told Ms. Truly that he does not like looking at Excel spreadsheets (he actually said, “these gobbledygooks give me a headache”), and he requested that Ms. Truly not show him any. He would prefer a word-processed document containing the cash budget and analyses.
- To make things easier and more efficient, Ms. Truly asked the office intern (Mr. John Jones, a third-year student in the Princess University undergraduate business program) to build a spreadsheet program that will allow them to simply enter the sales figures and quickly produce the cash budget. Mr. Jones did that, but unfortunately, he returned to his studies before he could check the accuracy of the spreadsheet program. There appears to be some errors in the program, as the numbers did not add up when Ms. Truly input the sales figures from last year. Ms. Truly can either look through the spreadsheet program (Cash Budget Builder.xlsx) and find and fix the errors, or build her own cash budget manually.
- Note to students: Since setting up and building a budget spreadsheet is a big undertaking, you may choose to use the incorrect spreadsheet program (Cash Budget Builder.xlsx). If you do, make sure that you find and fix the errors before you do your case study analysis. One way to know that the errors have been fixed is when your cash budget reveals the same numbers as the one provided in the case.
Marking Rubric
Item | Available marks |
Cash Budget | 40 |
1 | 10 |
2 | 5 |
3 | 25 |
4 | 15 |
5 | 5 |
Total | 100 |
BidSay HelloAnswerGet Paid Requirements Formatting: High School Spanish This student has a history of requesting refunds at a higher rate than other users. (12%) To avoid disputes, make sure your help satisfies their requirements. Lección 5B Primera Parte Gramática | Interactive Activity 14 – ¿A quién conociste?
Lección 5B Primera Parte Gramática | Interactive Activity 14 – ¿A quién conociste?
Original Post – Step 1: Using the activity above as a guide, write two separate stories – one event should be true and one event should be made up. Your classmates will have to determine which activity is a lie and which is true. See the word document attached to view the detailed instructions.
Response Post – Step 2: Read your classmates posts and try to figure out which of their stories is true and which one is made up. Respond to their posts by guessing which one you think is true and which one you think is made up. (Cierto o Falso). After someone posts their guess about your stories, response to them and tell them if they are correct or not (For example: Tienes razón, el número 1 es falso.).
Student responses:
Student 1.
Conoci a Elle en 2021. La conoci en el dormitorio de mis veinos, estaba con una amiga cuando nos conocimos. pense que eramos muy parecidos y ella era muy bonita. Ella se presento a mi, estaba muy feliz de conocerla.
Conoci a Beyonce en 2019. Estaba en mi casa cuando la conoci, estaba con kim kardashian cuando la conoci. ella era muy agradable y una gran cantante. ella se presento a mi, estaba muy nervioso por conocerla
Student 2.
conozco a Ian Ziering, Es un amigo de mi papa desde que era niño. Es un buen hombre.
conozco a Ariana grande. ella fue a mi escuela secundaria y tuve una class con ella. ella es bonita y me conoce bien.
CLP 314 abnormal psychology
Read Chapter 5 and write a 5-page paper explaining how social phobia can cause panic attacks and how that might develop into a disorder. Use APA 7th Edition Format.
Read the following article: Gene-Environment Interaction in Panic Disorder and Posttraumatic Stress Disorder. Battaglia, Marco. Canadian Journal of Psychiatry, Feb2013, Vol. 58 Issue 2, p69-75, 7p.
Required Text |
Nevid, J.S; Rathus, S.A. & Greene, B. S. (2021). Abnormal Psychology in a Changing World, 11rd Edition. Publisher: Pearson
ISBN: 9780135792049, 0135792045 |