Prepare a formal cash flow statement

Assignment Help Financial Accounting
Reference no: EM131683658

Question 1

Bill is shopping for a new car that is priced the same at two dealers for $42,000 . The difference in the offers of the two dealers is the financing arrangements as follows.

Dealer A has offered $7,000 as a trade-in on his old car, is offering the new car for payments of $799.00 monthly for four years.

Dealer B has offered $8,000 as the trade-in value and is offering the new car for lower payments of $649.00 monthly but for 5 years.

If both options are financially feasible for Bill and everything else is equal, which offer is the best financially?

Question 2
Veronica has decided to use her wealth to start a consumer loan business for residential home improvements. She will offer three types of loans with each having different compounding frequencies as shown below. Assume 52 weeks per year , 7 days per week, and 52 * 7 = 364 days per year
Determine the equal period payments for each alternative below to enable Veronica to earn 10% EAR on a $10,000 loan if they are paid off in full in two years?
a Determine the weekly payment with weekly compounding of interest.
c Determine the bi-weekly payment with bi-weekly Compounding of interest.
d Determine the monthly payment with daily compounding of interest.

Question 3

Maria and Salvador have a grand plan. They will deposit their combined annual bonuses and other savings of $10,000 annually (annual end of year deposits) for the upcoming ten years and then take a year off from their jobs and live it up in Paris during year 11 by withdrawing $8,000 monthly at the beginning of each month. They also will withdraw an additional $15,000 at the end of year 10 for airfare, setting up an apartment. etc. The annuity in which they will invest pays an nominal annual rate of 4.75% compounded monthly.
How much will they have at the end of the Paris diversion (end of year 11) to pay for flying home and transitioning back to work?

Question 4

Ellen is planning her retirement and has $1,000,000 in an annuity that earns 5% NAR compounded monthly.
a How many years can she receive benefits if she takes out $6,000 at beginning of each month if she reserves $50,000 to give to each of her two children when she dies?
b How much can she withdraw at the beginning of each month if she plans a future lifespan of 30 years if she reserves $50,000 for each of her two children when she dies?

Question 5

Barney has $232,000 remaining in his retirement account that earns 6% NAR compounded monthly. He is 70 years old and wants to ease into retirement over ten years by withdrawing $50,000 today and then gradually deplete the fund by reducing the amount withdrawn by $5,000 each year thereafter (e.g. withdraw $50,000 today, withdraw $45,000 at the end of year 1, $40,000 at the end of year 2, through $0.00 in year 10). He will live on social security and Medicare after the retirement funds are depleted. Is this scheme possible? Explain why or why not. Assume end of year withdrawals.

Question 6

Tim has inherited $200,000 that he is going to invest. He has narrowed down his choice to two investments.
Shares of a stock that can be purchased for $200 per share and is expected to pay dividends of $5 a share quarterly, and sold for $400 in 10 years.
A bond that can be purchased for $200,000, has a coupon rate of 4.125% paid semi-annually, and a face value of $250,000 that matures in 10 years
a Which should Tim choose to maximize the return on his investment. Explain why.
b What else should Marion consider when making a choice?

Question 7

An investment advisor forecasts quarterly dividends for Underground Materials Corporation (UMC) stock as shown below. If the stock is forecasted to be selling for $175 at the end of 2015, what should one pay for this stock today to earn a 15% effective annual rate.

Year 2014 2014 2015 2015 2015 2015
Quarter 3 4 1 2 3 4
Dividends $2.00 $3.00 $3.50 $3.50 $4.00 $4.00

Question 8

Ceyland Custom Prototypes, Inc. (CCP) has collected the following data for the past year. Prepare a formal income statement that contains the relevant subtotals. Show values in whole dollars (no cents). Assume that no taxes are due on asset purchases or sales.

Data Block Beginning of year During Year End of year

Materials Inventory $12,500
$14,000

Finished Inventory $7,800
$6,000

Accounts Receivable $74,000
$38,000

Accounts Payable $68,000
$62,000

Cash On Hand $330,500


Revenue
$1,336,128

Direct Production Costs
$412,560

Future Orders
$127,000

Staff Expenses
$424,600

Facility Expenses
$287,200

Asset Sale
$234,000

Asset Purchase
$2,500,000

Depreciation
$81,000

Interest Paid on Loan
$66,000

New Loan
$2,000,000

Dividends
$22,800

Income Tax rate
20%

Question 9

Hatcher Home Housewares, Inc. (HHH) has collected the following data for the past year. Assume that no taxes are due on asset purchases or sales. Prepare a formal cash flow statement that contains the relevant subtotals. Show values in whole dollars (no cents).


Beginning of year During Year End of year
Materials Inventory $12,500
$14,000
Finished Inventory $7,800
$6,000
Accounts Receivable $74,000
$38,000
Accounts Payable $68,000
$62,000
Cash On Hand $330,500

Revenue
$1,296,360
Direct Production Costs
$412,560
Future Orders
$127,000
Staff Expenses
$424,600
Facility Expenses
$287,200
Asset Sale
$234,000
Asset Purchase
$2,500,000
Depreciation
$81,000
Interest Paid on Loan
$66,000
New loan
$2,000,000
Dividends
$22,800
Income Tax rate
20%
Net Income
$20,000

Question 10

Acme Family Products and Sullivan and Sons, two proprietorships and former competitors, are planning a merger. Everything looks in order but a choice of organization type has not been made. What factors and issues would affect their decision whether to organize as a proprietorship, partnership, LLC, or a corporation?

Record your answer below or submit in a Word document.

Reference no: EM131683658

Questions Cloud

The benefits of using big data for the average firm : How will big data affect the consumer? What do you think will be the benefits of using Big Data for the average firm.
List of phobias and their effect on personality : Is Child Obesity a Reflection of Parental Negligence?Change of Perception Based on Attractiveness - Are the Attractive Treated Differently?
Discuss ap human geography : AP Human geography and i have absolutely no idea what the set definition of it is
What procedure would users follow to delete their profiles : Visit StumbleUpon and two other bookmarking services. If necessary, sign in to these services and compare the features. How do users select the categories.
Prepare a formal cash flow statement : Determine the weekly payment with weekly compounding of interest and determine the bi-weekly payment with bi-weekly Compounding of interest
Discuss the geologic history of the area : discuss the geologic history of the area where you live or grew up. Discuss some of the major factors that might have played a role in shaping
Drew a database diagram with the entities and attributes : Drew a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).
Problem solving cases in microsoft access : Review Tutorial A in the Problem Solving Cases in Microsoft Access and Excel workbook
Identify basic spatial and geographic data analysis skills : Describe the world's regions through recognizing their physical and human dimensions

Reviews

Write a Review

Financial Accounting Questions & Answers

  Briefly describe the ethical environment that led to fraud

What should the statement of owner's equity look like if there is no withdraw for the year? Describe how having a high accounts receivable turnover could be bad for a firm. Briefly describe the ethical environment that led to fraud. What specific act..

  What is junes direct material efficiency variance

Robb Industries, Inc. (RII), developed standard costs for direct material and direct labor. In 2004, RII estimated the following standard costs for one of their major products, the 10-gallon plastic container. What is June’s direct material price var..

  Prepare the may income statement through gross profit

Estimate the May 31 inventory, using the gross profit method and prepare the May income statement through gross profit for Halloween Costumes.

  Product unit cost for one pillow based on the costing

Pretty Pillows, Mfg., manufactures silk throw pillows. Last month the company produced 3,890 pillows. Using job order costing, determine the product unit cost for one pillow based on the following costs: production facility utilities, $1,600; depreci..

  Q1 consider the multi-factor apt with two factorsnbsp the

q1. consider the multi-factor apt with two factors.nbsp the risk premiums on the factor 1 and factor 2 portfolios are

  How much is owners equity at the end of the year

Burlin Company starts the year with $108,000 in assets and $21,600 in liabilities. Net income for the year is $27,000, and no dividends are paid. How much is owners' equity at the end of the year?

  Determine the expected net realizable value

Balance in the allowance account after the adjustment of December 31. Expected net realizable value of the accounts receivable as of December 31.

  What is the total target cost for this products life

Praeuner Company has surveyed the market and set a target selling price of $2,000 per unit for its product. Praeuner believes it can sell 100,000 units of this product over its two-year life.

  Interest charges were earned for current and preceding years

The following data were taken from recent annual reports of Caliber Company, which operates a low-fare company service to over 50 cities in the United States. Current Year Preceding Year Interest expense $42,000 $46,000 Income before income tax 247,8..

  Account for insurance expense

Account for insurance expense. (LO 1, 3). Vertigo Company paid $10,000 on July 1, 2009, for a two-year insurance policy. It was recorded as prepaid insurance. Use the accounting equation to show the adjustment Vertigo will make to properly report exp..

  Williams music store reported cost of goods sold

williams music store reported cost of goods sold as

  What does the scanlon plan mean need examples

What does the scanlon plan mean? need examples to explain it.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd