Comparative financial statement data for Carmono Company follow:
| This Year | Last Year | ||||
| Assets | |||||
| Cash | $ | 8.50 | $ | 16.00 | |
| Accounts receivable | 54.00 | 47.00 | |||
| Inventory | 97.50 | 84.40 | |||
| Total current assets | 160.00 | 147.40 | |||
| Property, plant, and equipment | 237.00 | 198.00 | |||
| Less accumulated depreciation | 47.20 | 35.40 | |||
| Net property, plant, and equipment | 189.80 | 162.60 | |||
| Total assets | $ | 349.80 | $ | 310.00 | |
| Liabilities and Stockholders’ Equity | |||||
| Accounts payable | $ | 58.50 | $ | 48.00 | |
| Common stock | 126.00 | 97.00 | |||
| Retained earnings | 165.30 | 165.00 | |||
| Total liabilities and stockholders’ equity | $ | 349.80 | $ | 310.00 | |
For this year, the company reported net income as follows:
| Sales | $ | 950.00 |
| Cost of goods sold | 570.00 | |
| Gross margin | 380.00 | |
| Selling and administrative expenses | 360.00 | |
| Net income | $ | 20.00 |
This year Carmono declared and paid a cash dividend. There were no sales of property, plant, and equipment during this year. The company did not repurchase any of its own stock this year.
Required:
1. Using the indirect method, prepare a statement of cash flows for this year.
2. Compute Carmono’s free cash flow for this year.
Using the indirect method, prepare a statement of cash flows for this year. (List any deduction in cash and cash outflows as negative amounts. Round your intermediate calculations and final answers to 2 decimal places.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Compute Carmono’s free cash flow for this year. (Negative amount should be indicated by a minus sign. Round your intermediate calculations and final answer to 2 decimal places.)
|
In: Accounting
Your 40-year clients, who have a 12-year old child, plan to retire at the age of 62. Assume 360-day year and 30-day month in your calculations.
They have a current salary at an annual rate of $144000, being paid equally at the end of each month. They expect a 3% raise in their salary every year until they retire. They deposit 12% of their monthly salary to their 401(k) account that generates an annual rate of return of 10%, compounded daily. In addition, their employer matches their contribution with 5% of their salary to the same 401(k) account.
Currently, annual college expenses are running at $30,000, and are expected to grow at an annual rate of 5%. Their child is expected to enter college when she turns 18, and complete the degree program in 5 years. Your clients expect their child to be responsible for 20% of college expenses via the work-study program. All annual college expenses are due at the beginning of each year. Your clients plan to tap into the 529 Plan account for paying their child’s college expenses. Is there sufficient funding in the 529 account for financing their child’s college expenses? If not, when will the funding run out of money? Support your answers numerically.
In: Finance
Your 40-year clients, who have a 12-year old child, plan to retire at the age of 62. Assume 360-day year and 30-day month in your calculations.
They have a current salary at an annual rate of $144000, being paid equally at the end of each month. They expect a 3% raise in their salary every year until they retire. They deposit 12% of their monthly salary to their 401(k) account that generates an annual rate of return of 10%, compounded daily. In addition, their employer matches their contribution with 5% of their salary to the same 401(k) account.
At the end of each year, your clients will receive a bonus of 15% of their annual salary. Your clients commit to deposit part of their annual bonus, $15,000, in a 529 Plan account each year for financing their child’s college education. They will keep contributing to the 529 account until their child finishes college. Any remaining amount from the annual bonus check will be deposited in an IRA account. Both of these accounts are expected to generate an annual rate of return of 9%, compounded monthly.
1. Determine the cash flows pattern of their contributions to the IRA account; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. And calculate their IRA account balance upon their retirement.
2. Determine the cash flows pattern of their contributions to the 529 Plan account; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. And calculate the 529 Plan account balance at the time their child starts college.
In: Finance
Forten Company's current year income statement, comparative
balance sheets, and additional information follow. For the year,
(1) all sales are credit sales, (2) all credits to Accounts
Receivable reflect cash receipts from customers, (3) all purchases
of inventory are on credit, (4) all debits to Accounts Payable
reflect cash payments for inventory, and (5) Other Expenses are
paid in advance and are initially debited to Prepaid
Expenses.
| FORTEN COMPANY Comparative Balance Sheets December 31 |
|||||||||||
| Current Year | Prior Year | ||||||||||
| Assets | |||||||||||
| Cash | $ | 72,400 | $ | 88,500 | |||||||
| Accounts receivable | 88,420 | 65,625 | |||||||||
| Inventory | 298,156 | 266,800 | |||||||||
| Prepaid expenses | 1,360 | 2,195 | |||||||||
| Total current assets | 460,336 | 423,120 | |||||||||
| Equipment | 142,500 | 123,000 | |||||||||
| Accum. depreciation—Equipment | (44,125 | ) | (53,500 | ) | |||||||
| Total assets | $ | 558,711 | $ | 492,620 | |||||||
| Liabilities and Equity | |||||||||||
| Accounts payable | $ | 68,141 | $ | 137,175 | |||||||
| Short-term notes payable | 14,500 | 9,000 | |||||||||
| Total current liabilities | 82,641 | 146,175 | |||||||||
| Long-term notes payable | 57,500 | 63,750 | |||||||||
| Total liabilities | 140,141 | 209,925 | |||||||||
| Equity | |||||||||||
| Common stock, $5 par value | 185,250 | 165,250 | |||||||||
| Paid-in capital in excess of par, common stock | 60,000 | 0 | |||||||||
| Retained earnings | 173,320 | 117,445 | |||||||||
| Total liabilities and equity | $ | 558,711 | $ | 492,620 | |||||||
| FORTEN COMPANY Income Statement For Current Year Ended December 31 |
|||||||
| Sales | $ | 657,500 | |||||
| Cost of goods sold | 300,000 | ||||||
| Gross profit | 357,500 | ||||||
| Operating expenses | |||||||
| Depreciation expense | $ | 35,750 | |||||
| Other expenses | 147,400 | 183,150 | |||||
| Other gains (losses) | |||||||
| Loss on sale of equipment | (20,125 | ) | |||||
| Income before taxes | 154,225 | ||||||
| Income taxes expense | 45,250 | ||||||
| Net income | $ | 108,975 | |||||
Additional Information on Current Year Transactions
1. Prepare a complete statement of cash flows using the indirect method for the current year.
In: Accounting
A stock has had the following year-end prices and
dividends:
| Year | Price | Dividend | ||||||||||||
| 1 | $ | 64.23 | — | |||||||||||
| 2 | 71.10 | $ | .58 | |||||||||||
| 3 | 76.90 | .63 | ||||||||||||
| 4 | 63.17 | .69 | ||||||||||||
| 5 | 72.91 | .78 | ||||||||||||
| 6 | 78.75 | .85 | ||||||||||||
|
What are the
arithmetic and geometric returns for the stock?
(Do not round
intermediate calculations and enter your answers as a percent
rounded to 2 decimal places, e.g.,
32.16.)
|
||||||||||||||
In: Finance
Your 40-year clients, who have a 12-year old child, plan to retire at the age of 62. Assume 360-day year and 30-day month in your calculations.
They have a current salary at an annual rate of $144,000, being paid equally at the end of each month.
They expect a 3% raise in their salary every year until they retire.
They deposit 12% of their monthly salary to their 401(k) account that generates an annual rate of return of 10%, compounded daily.
In addition, their employer matches their contribution with 5% of their salary to the same 401(k) account.
Q1 Determine the cash flows pattern of the total monthly contributions to the 401(k)
account within each year; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER,
used in your analysis. And calculate the year-end value of the 401(k) contributions for each year.
Q2 Determine the pattern of the year-end values of the 401(k) contributions across years;
and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. And calculate their 401(k) account balance upon their retirement.
In: Finance
2) PROJECT CASH FLOW
Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project:
| Sales revenues | $25 million |
| Operating costs (excluding depreciation) | 17.5 million |
| Depreciation | 5 million |
| Interest expense | 5 million |
The company has a 40% tax rate, and its WACC is 11%.
Write out your answers completely. For example, 13 million should be entered as 13,000,000.
What is the project's cash flow for the first year (t = 1)?
Round your answer to the nearest dollar.
_______________$
If this project would cannibalize other projects by $2.5 million
of cash flow before taxes per year, how would this change your
answer to part a? Round your answer to the nearest dollar.
The firm's project's cash flow would now be $____________ .
Ignore part b. If the tax rate dropped to 35%, how would that
change your answer to part a? Round your answer to the nearest
dollar.
The firm's project's cash flow would increase by $
____________.
In: Finance
Roth Inc. experienced the following transactions for Year 1, its
first year of operations:
| Number of Days Past Due |
Amount | Percent Likely to Be Uncollectible |
Allowance Balance |
||||||
| Current | $ | 31,200 | 0.01 | ||||||
| 0−30 | 13,000 | 0.05 | |||||||
| 31−60 | 2,600 | 0.10 | |||||||
| 61−90 | 2,600 | 0.20 | |||||||
| Over 90 days | 2,600 | 0.50 | |||||||
Required
a. Record the above transactions in general
journal form and post to T-accounts. (If no entry is
required for a transaction/event, select "No journal entry
required" in the first account field.)
Journal entry worksheet
Note: Enter debits before credits.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Forten Company's current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) Other Expenses are paid in advance and are initially debited to Prepaid Expenses.
| FORTEN COMPANY Comparative Balance Sheets December 31 |
|||||||||||
| Current Year | Prior Year | ||||||||||
| Assets | |||||||||||
| Cash | $ | 49,800 | $ | 73,500 | |||||||
| Accounts receivable | 65,810 | 50,625 | |||||||||
| Inventory | 275,656 | 251,800 | |||||||||
| Prepaid expenses | 1,250 | 1,875 | |||||||||
| Total current assets | 392,516 | 377,800 | |||||||||
| Equipment | 157,500 | 108,000 | |||||||||
| Accum. depreciation—Equipment | (36,625 | ) | (46,000 | ) | |||||||
| Total assets | $ | 513,391 | $ | 439,800 | |||||||
| Liabilities and Equity | |||||||||||
| Accounts payable | $ | 53,141 | $ | 114,675 | |||||||
| Short-term notes payable | 10,000 | 6,000 | |||||||||
| Total current liabilities | 63,141 | 120,675 | |||||||||
| Long-term notes payable | 65,000 | 48,750 | |||||||||
| Total liabilities | 128,141 | 169,425 | |||||||||
| Equity | |||||||||||
| Common stock, $5 par value | 162,750 | 150,250 | |||||||||
| Paid-in capital in excess of par, common stock | 37,500 | 0 | |||||||||
| Retained earnings | 185,000 | 120,125 | |||||||||
| Total liabilities and equity | $ | 513,391 | $ | 439,800 | |||||||
| FORTEN COMPANY Income Statement For Current Year Ended December 31 |
|||||||
| Sales | $ | 582,500 | |||||
| Cost of goods sold | 285,000 | ||||||
| Gross profit | 297,500 | ||||||
| Operating expenses | |||||||
| Depreciation expense | $ | 20,750 | |||||
| Other expenses | 132,400 | 153,150 | |||||
| Other gains (losses) | |||||||
| Loss on sale of equipment | (5,125 | ) | |||||
| Income before taxes | 139,225 | ||||||
| Income taxes expense | 24,250 | ||||||
| Net income | $ | 114,975 | |||||
Additional Information on Current Year Transactions
In: Accounting
In: Finance