|
Using the following information, prepare the Statement of Cash Flows for Corbett Enterprises for the year ended December 31, 2017 in the Answer sheet in this Excel spreadsheet. Place parentheses around those figures in the statement representing cash outlays. Then answer the 4 multiple choice questions in the Answer sheet in this Excel spreadsheet. Notice that the ? is beside Cash received from customers. You will need to prepare the Statement of Cash Flows with the other amounts and solve for Cash received from customers. |
||||||||
|
Cash paid to acquire marketable securities |
$370,000 |
|||||||
|
Proceeds from sale of marketable securities |
17,500 |
|||||||
|
Proceeds from issuance of capital stock |
280,000 |
|||||||
|
Proceeds from issuance of bonds payable |
55,000 |
|||||||
|
Payments to settle short-term debt |
32,500 |
|||||||
|
Interest and dividends received |
10,000 |
|||||||
|
Cash received from customers |
? |
|||||||
|
Dividends paid |
130,000 |
|||||||
|
Cash paid to suppliers and employees |
1,030,000 |
|||||||
|
Interest paid |
25,000 |
|||||||
|
Income taxes paid |
70,000 |
|||||||
|
Cash and cash equivalents, January 1, 2010 |
43,000 |
|||||||
|
Cash and cash equivalents, December 31, 2010 |
58,000 |
|||||||
|
Cash flows from operating activities: |
||||||||
|
Cash provided by operating activities |
$0 |
|||||||
|
Cash paid to suppliers and employees |
||||||||
|
Cash disbursed for operating activities |
- |
|||||||
|
Net cash flows ________ by operating activities: |
$0 |
|||||||
|
Cash flows from investing activities: |
||||||||
|
Net cash _______ by investing activities |
0 |
|||||||
|
Cash flows from financing activities: |
||||||||
|
Net cash ________ by financing activities |
0 |
|||||||
|
Net increase (decrease) in cash |
$0 |
|||||||
|
Cash and cash equivalents, beginning of year |
||||||||
|
Cash and cash equivalents, end of year |
$0 |
|||||||
|
Using the above information, indicate the best answer for each question in the space provided to the left of the question. |
||||||||
|
1 |
Corbett Enterprises' cash flow from investing activities during 2010 is: |
|||||||
|
a. $390,000 net cash used by investing activities. |
||||||||
|
b. $322,500 net cash provided by investing activities. |
||||||||
|
c. $352,500 net cash used by investing activities. |
||||||||
|
d. $360,000 net cash used by investing activities. |
||||||||
|
2 |
Corbett Enterprises' cash flow from financing activities during 2010 is: |
|||||||
|
a. $322,500 net cash provided by financing activities. |
||||||||
|
b. $172,500 net cash provided by financing activities. |
||||||||
|
c. $127,500 net cash provided by financing activities. |
||||||||
|
d. $375,000 net cash provided by financing activities. |
||||||||
|
3 |
Corbett Enterprises' cash flow from operating activities during 2010 is: |
|||||||
|
a. $45,000 net cash provided by operating activities. |
||||||||
|
b. $1,155,000 net cash used by operating activities. |
||||||||
|
c. $240,000 net cash provided by operating activities. |
||||||||
|
d. $195,000 net cash provided by operating activities. |
||||||||
|
4 |
In the 2010 statement of cash flows for Corbett Enterprises, the amount of cash received from customers is: |
|||||||
|
a. $1,310,000 |
||||||||
|
b. $1,103,000 |
||||||||
|
c. $1,233,000 |
||||||||
|
d. $1,293,000 |
||||||||
In: Finance
An asset’s price is $68.14 and its volatility is 30% per year. A European put on the asset has three months until expiration, a strike price of $70.00, and the risk-free interest rate is 2.2% per year. According to a one-period binomial option pricing model, what is the option’s value?
In: Finance
In: Finance
A 5-year project requires a $300,000 investment in a machine that is expected to worth $50,000 when the project ends. Operating expenses are expected to be $75,000 in the first year and are expected to increase 3% per year over the life of the project. The appropriate discount rate is 8%, the company’s tax rate is 20%, and the CCA rate is 30%. What amount would you use for salvage value in your NPV calculation?
In: Finance
Maynard Company projects the following sales for the first three months of the year: $15800 in January; $15,900 in February; $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar.
Requirements:
1.) Prepare a schedule of cash receipts for Maynard for January, February, and March. What is the balance in Accounts Receivable on March 31?
2.) Prepare a revised schedule of cash receipts if receipts from sales on account are 70% in the month of the sale, 10% in the month following the sale, and 20% in the second month following the sale. What is the balance in Accounts Receivable on March 31?
Requirement 1. Prepare a schedule of cash receipts for
Maynard
for
January?,
February?,
and
March.
What is the balance in Accounts Receivable on
MarchMarch
31??
?(Leave unused and zero balance account cells? blank, do not enter? "0".)
|
Cash Receipts from Customers |
|||||
|
January |
February |
March |
Total |
||
|
Total sales |
15800 |
15900 |
11100 |
42800 |
|
|
January |
February |
March |
Total |
||
|
Cash Receipts from Customers: |
|||||
|
Accounts Receivable balance, January 1 |
|||||
|
January—Cash sales |
|||||
|
January—Credit sales, collection of January sales in January |
|||||
|
January—Credit sales, collection of January sales in February |
|||||
|
February—Cash sales |
|||||
|
February—Credit sales, collection of February sales in February |
|||||
|
February—Credit sales, collection of February sales in March |
|||||
|
March—Cash sales |
|||||
|
March—Credit sales, collection of March sales in March |
|||||
|
Total cash receipts from customers |
|||||
|
Accounts Receivable balance, March 31: |
|||||
|
March—Credit sales, collection of March sales in April |
|||||
In: Accounting
|
Pearl Corp. is expected to have an EBIT of $3,200,000 next year. Depreciation, the increase in net working capital, and capital spending are expected to be $160,000, $145,000, and $185,000, respectively. All are expected to grow at 16 percent per year for four years. The company currently has $16,500,000 in debt and 1,150,000 shares outstanding. After Year 5, the adjusted cash flow from assets is expected to grow at 3 percent indefinitely. The company’s WACC is 8.8 percent and the tax rate is 24 percent. |
|
What is the price per share of the company's stock? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
Please show formulas for excel. Thanks!
In: Finance
a 68 year old Male presents to the e m.j Regency department with complainants of a 2- day history of difficulty breathing, cough, a d chest pain. Upon triage assessment, the patient is found to have a fever, increased work of breathing, decreased oxygen saturation, and crackers upon asculation of the lungs. A chest x ray reveals considation in the right upper ly g field. The patient is diagnosed with pneumonia, initiated on oxygen therapy, and admitted for observation and treatment. As The RN, you document t the care and assessment of the patient in the chart prior to transfer to an inpatient unit. what is the most appropriate term for the clinical manifestation of disease as reported by the patient?
In: Anatomy and Physiology
An asset’s price is $29.00 and its volatility is 29% per year. A European put on the asset has an exercise price of $30.00, eighteen months until expiration, and the risk-free interest rate is 3.8% per year. According to a two-period binomial option pricing model, what is the option’s value?
|
|||
|
|||
|
|||
|
|||
|
In: Finance
What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an interest rate of 5.125 percent.
A friend who knows you have studied amortization asks your help to find the interest portion of their house payments for tax purposes (assuming they itemize). The monthly payments are $2,107.02 on a 30 year loan with a 5 percent interest rate.
a) What was the total amount of interest paid during year 2?
b) At what point in time was/will the loan balance be
reduced to 50 percent of the original loan amount?
Thank you!
In: Finance
Portfolio A has an expected return of 10% per year and a standard deviation of 20% per year, while the risk-free asset returns 2% per year.
a. What is the expected return of a portfolio consisting the risk-free asset and portfolio A that has a standard deviation of 15%?
b. What is the portfolio weight on A of a portfolio consisting the risk-free asset and portfolio A that has a standard deviation of 15%?
c. What is the standard deviation of a portfolio consisting the risk-free asset and portfolio A that has an expected return of 6%?
In: Finance