Gears is a 5-year-old company that specializes in bike components. The company is having trouble paying...

Gears is a 5-year-old company that specializes in bike components. The company is having trouble paying for its monthly supplies and would like to perform a cash flow analysis so it can understand its financial position. Cash flow represents the money an investment produces after subtracting cash expenses from income. The statement of cash flows summarizes sources and uses of cash, indicates whether enough cash is available to carry on routine operations, and offers an analysis of all business transactions, reporting where the firm obtained its cash and how it chose to allocate the cash. The cash flow statement shows where money comes from, how the company will spend it, and when the company will require additional cash. Gears would like to project a cash flow statement for the next month.

Using the AYK2_Data.xlsx data file, complete the cash flow statement for Gears, using Excel. Be sure to create formulas so the company can simply input numbers in the future to determine cash flow.


	Gears Cash Flow Statement January
	Cash on Hand (beginning of month)	$ 18,456

	CASH RECEIVED
	Cash Sales	$ 23,894
	Credit Sales Accounts	$ 36,421
	TOTAL CASH RECEIVED

	CASH PAID OUT
	Inventory	$ 15,340
	Payroll expenses	$ 17,560
	Supplies (office & oper.)	$ 4,500
	Repairs & maintenance	$ 3,500
	Advertising	$ 2,890
	Car, delivery & travel	$ 1,500
	Accounting & legal	$ 750
	Rent	$ 4,000
	Telephone	$ 120
	Utilities	$ 430
	Insurance	$ 1,020
	Taxes (real estate, etc.)	$ 600
	Miscellaneous	$ 350
	TOTAL CASH PAID OUT

	CASH POSITION (END OF MONTH)

Input boxes in tan

Output boxes in yellow

Given data in blue

Answers in red

Expert Solution

jeff jeffy answered 2 years ago

1) Compute the Macaulay duration for a 5-year bond paying annual coupons of 9% and having...

1) Compute the Macaulay duration for a 5-year bond paying annual coupons of 9% and having a yield to maturity of 9.5%. a. 3.86 Answers: a. 3.86 b. 4.57 c. 5.00 d. 3.78 e. 4.23 2) Which of the following bonds would be cheapest to deliver given a T-note futures price of 90.4697? (Assume that all bonds have semiannual coupon payments based on a par value of $100.) Answers: a. 9.5-year bond with 4.5% coupons and a yield of 3.5%...

Red Company prepared the following budget information for the coming year: Bike A Bike B Bike...

Red Company prepared the following budget information for the coming year: Bike A Bike B Bike C Total Sales $75,000 $1,000,000 $160,000 $1,235,000 Variable expenses 25,000 800,000 80,000 905,000 Contribution margin $50,000 $200,000 $80,000 $330,000 Fixed expense 230,000 Operating income $100,000 The budget assumes the sale of 30,000 units of Bike A, 110,000 units of Bike B, and 60,000 units of Bike C. INSTRUCTIONS: a) What is the company's break-even point in sales dollars given the sales mix above? b)...

The Delta Insurance Company is having a policyholder subsystem which has started giving trouble. Over the...

The Delta Insurance Company is having a policyholder subsystem which has started giving trouble. Over the years, the application evolved from using fixed length, multi-record type files to using a hierarchic database to using a relational database. The programs did not change much, but the data structures changed radically. Program code was patched to provide for the new data structure. The amount of people-time allocated to policyholder maintenance grew 15% per year over the last five years and is now...

A year ago, you purchased a 5-year bond, paying fixed annual coupons at a rate 5%pa....

A year ago, you purchased a 5-year bond, paying fixed annual coupons at a rate 5%pa. At the time you purchased the bond, the yield to maturity was 5%pa. If you sold the bond after receiving the first interest payment and the bond's yield to maturity had changed to 4%, your annual total rate of return on holding the bond for that year would have been approximately ________. Group of answer choices 8.1% 4.8% 8.6% 7.6% 9.5% PreviousNext

Mr. K., a 34-year-old male, was involved in a mountain bike crash. He was wearing a...

Mr. K., a 34-year-old male, was involved in a mountain bike crash. He was wearing a helmet, but he was traveling at a high speed down the mountain when he hit a rock and was sent over his handlebars and slammed against a tree. Initially he was conscious and complaining of abdominal pain and intense left shoulder and arm pain. He was bleeding from multiple abrasions and lacerations on his face, arms, and legs. His friend who was biking with...

Mr. H is a 30-year-old man. He was riding his bike to work and was struck...

Mr. H is a 30-year-old man. He was riding his bike to work and was struck by a vehicle traveling at 35 miles per hour. He was comatose with a GCS 7 upon arrival to the ED. What are the leading causes of traumatic brain injury in the United States? Describe important teaching points in prevention of a TBI. Traumatic brain injury can be classified into primary brain injury and secondary injury, describe the differences in the two types of injury. List common...

California Circuits Company (3C) manufactures a variety of components. Its Valley plant specializes in two electronic...

California Circuits Company (3C) manufactures a variety of components. Its Valley plant specializes in two electronic components used in circuit boards. These components serve the same function and perform equally well. The difference in the two products is the raw material. The XL-D chip is the older of the two components and is made with a metal that requires a wash prior to assembly. Originally, the plant released the wastewater directly into a local river. Several years ago, the company...

Donna is a 35 year old female who is married and has a 5 year old...

Donna is a 35 year old female who is married and has a 5 year old daughter. Donna recently found out she was pregnant, but last week at 12 weeks she started to spot and went to see the doctor. At the doctors, Donna found out she was having a miscarriage and the doctors decided to look at her blood type and seemed very alarmed and asked her who her doctor was for her first child. Her blood type was...

Question 5. Consider n components of a system having independently exponentially distributed lifetimes so that Xn...

Question 5. Consider n components of a system having independently exponentially distributed lifetimes so that Xn ~ exp(θ) a) For a single component, find the reliability to time t1 + t2 given that the component has already lived past time t1. Why is the constant failure rate referred to as the “memory-less” property? b) For the series of n components, find an expression for Rs(t). What is the mean lifetime of the system?

Donald is a 62-year-old male who has been experiencing frequent urination and trouble starting to urinate...

Donald is a 62-year-old male who has been experiencing frequent urination and trouble starting to urinate for several weeks. He has a family history of benign prostatic hyperplasia. Donald’s BMI is 29, he occasionally drinks alcohol and coffee, and his diet consists mainly of red meat, starches, and dairy products. Just yesterday, he had an episode of incontinence and decided to seek care immediately. Donald was referred to an urologist who suspected that his prostate was the cause of his...

Question