THEO 100 Lecture 9: THEO 100 - Lecture 9 (1)

31 views1 pages

goldjellyfish848

19 Jun 2018

School

Department

Course

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

フ硤れ

次ん

な0。

卩,ゝ

内お"い

み可 /・

ら

0、

/第,

乙しし

7第」

猛カ

03ハ

み)を山

の女

ー7に

0 ~叮

をの

、

ん云を~い朝イ/~

。な "い3い自を・~ )。

"イ0パこ-

を工

を、第,第に引工ッ(ナ/

〃

イんを

0イ

れて

目リ

しの

い

イ

ノ

イレ当当ナ。

、

“ナり一-な

Unlock document

This preview shows half of the first page of the document.
Unlock all 1 pages and 3 million more documents.

Already have an account? Log in

Related Questions

Input Data
Month	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
Revenue		$ -	$ -	$ -	$ -	$ -	$ -	$ 2,500	$ 2,875	$ 3,306	$ 3,802	$ 4,373	$ 5,028	$ 5,783	$ 6,650	$ 7,648	$ 8,795	$ 10,114	$ 11,631	$ 13,376	$ 15,382	$ 17,689	$ 20,343	$ 23,394	$ 26,903
Monthly Revenue Growth Rate		0%	0%	0%	0%	0%	0%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%
Terms of Revenue
Cash Sales (% ofrevenue)		70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%
N30 (% ofrevenue)		30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%
N60 (% ofrevenue)		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Cost of Good Sold		8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%
Terms of Cost of Goods Sold
Cash Sales (% ofpurchases)		0%	0%	0%	0%	0%	0%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%
N30 (% ofpurchases)		0%	0%	0%	0%	0%	0%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%
N60 (% ofpurchases)		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Cash Operating Costs
Compensation		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Rent		200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200
Supplies		10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%
Other OperatingExpences		15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%
Accounting		$100	$100	$100	$100	$100	$100	$100	$115	$132	$152	$175	$201	$231	$266	$306	$352	$405	$465	$535	$615	$708	$814	$936	$1,076
Advertizing		$350	350	350	350	350	350	403	463	532	612	704	810	931	1071	1231	1416	1628	1873	2153	2476	2848	3275	3766	4331
Tax Rate		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%

Income Statement
Month	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
Revenue		$0	$0	$0	$0	$0	$0	$2,500	$2,875	$3,306	$3,802	$4,373	$5,028	$5,783	$6,650	$7,648	$8,795	$10,114	$11,631	$13,376	$15,382	$17,689	$20,343	$23,394	$26,903
Cost of Goods Sold		$0	$0	$0	$0	$0	$0	$200	$230	$265	$304	$350	$402	$463	$532	$612	$704	$809	$930	$1,070	$1,231	$1,415	$1,627	$1,872	$2,152
Gross Profit		$0	$0	$0	$0	$0	$0	$2,300	$2,645	$3,042	$3,498	$4,023	$4,626	$5,320	$6,118	$7,036	$8,091	$9,305	$10,701	$12,306	$14,151	$16,274	$18,715	$21,523	$24,751
Compensation		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Rent		200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200
Supplies		0	0	0	0	0	0	250	288	331	380	437	503	578	665	765	879	1,011	1,163	1,338	1,538	1,769	2,034	2,339	2,690
Other operating Expences		0	0	0	0	0	0	375	431	496	570	656	754	867	998	1,147	1,319	1,517	1,745	2,006	2,307	2,653	3,051	3,509	4,035
Accounting		100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
Advertizing		350	350	350	350	350	350	403	463	532	612	704	810	931	1,071	1,231	1,416	1,628	1,873	2,153	2,476	2,848	3,275	3,766	4,331
Earnings Before Taxes		-$650	-$650	-$650	-$650	-$650	-$650	$973	$1,163	$1,383	$1,635	$1,926	$2,259	$2,643	$3,085	$3,593	$4,176	$4,848	$5,620	$6,508	$7,529	$8,704	$10,054	$11,608	$13,394
Taxes		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Income		-$650	-$650	-$650	-$650	-$650	-$650	$973	$1,163	$1,383	$1,635	$1,926	$2,259	$2,643	$3,085	$3,593	$4,176	$4,848	$5,620	$6,508	$7,529	$8,704	$10,054	$11,608	$13,394

Cash Flow
Cash Collected from Revenue		$0	$0	$0	$0	$0	$0	$1,750	$2,763	$3,177	$3,653	$4,201	$4,832	$5,556	$6,390	$7,348	$8,451	$9,718	$11,176	$12,852	$14,780	$16,997	$19,547	$22,479	$25,850
Cash Payments on COGS		$0	$0	$0	$0	$0	$0	$0	$200	$230	$265	$304	$350	$402	$463	$532	$612	$704	$809	$930	$1,070	$1,231	$1,415	$1,627	$1,872
Cash Operating Expenses ETC		$650	$650	$650	$650	$650	$650	$1,328	$1,482	$1,659	$1,863	$2,097	$2,367	$2,677	$3,033	$3,443	$3,915	$4,457	$5,080	$5,797	$6,622	$7,570	$8,661	$9,915	$11,357
Taxes		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Cash Flow		-$650	-$1,301	-$1,951	-$2,601	-$3,251	-$3,902	-$3,479	-$2,398	-$1,110	$416	$2,216	$4,331	$6,809	$9,703	$3,373	$3,924	$4,558	$5,286	$6,124	$7,088	$8,196	$9,471	$10,936	$12,622

Cash Account Balance	$3,000	$2,350	$1,049	-$902	-$3,503	-$6,754	-$10,655	-$14,134	-$16,532	-$17,642	-$17,226	-$15,010	-$10,679	-$3,870	$5,833	$9,206	$13,130	$17,688	$22,974	$29,099	$36,187	$44,383	$53,854	$64,790	$77,412

Compute, if possible, how much revenue would be needed tobreakeven in terms of cash flow. Comment on the financial viabilityof the venture. Would you suggest any changes? If so, what arethey? If you do, this becomes your âbaseâ model.

blackfox171

Input Data
Month	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
Revenue		$ -	$ -	$ -	$ -	$ -	$ -	$ 2,500	$ 2,875	$ 3,306	$ 3,802	$ 4,373	$ 5,028	$ 5,783	$ 6,650	$ 7,648	$ 8,795	$ 10,114	$ 11,631	$ 13,376	$ 15,382	$ 17,689	$ 20,343	$ 23,394	$ 26,903
Monthly Revenue Growth Rate		0%	0%	0%	0%	0%	0%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%
Terms of Revenue
Cash Sales (% ofrevenue)		70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%
N30 (% ofrevenue)		30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%
N60 (% ofrevenue)		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Cost of Good Sold		8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%
Terms of Cost of Goods Sold
Cash Sales (% ofpurchases)		0%	0%	0%	0%	0%	0%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%
N30 (% ofpurchases)		0%	0%	0%	0%	0%	0%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%
N60 (% ofpurchases)		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Cash Operating Costs
Compensation		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Rent		200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200
Supplies		10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%	10%
Other OperatingExpences		15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%	15%
Accounting		$100	$100	$100	$100	$100	$100	$100	$115	$132	$152	$175	$201	$231	$266	$306	$352	$405	$465	$535	$615	$708	$814	$936	$1,076
Advertizing		$350	350	350	350	350	350	403	463	532	612	704	810	931	1071	1231	1416	1628	1873	2153	2476	2848	3275	3766	4331
Tax Rate		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%

Income Statement
Month	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
Revenue		$0	$0	$0	$0	$0	$0	$2,500	$2,875	$3,306	$3,802	$4,373	$5,028	$5,783	$6,650	$7,648	$8,795	$10,114	$11,631	$13,376	$15,382	$17,689	$20,343	$23,394	$26,903
Cost of Goods Sold		$0	$0	$0	$0	$0	$0	$200	$230	$265	$304	$350	$402	$463	$532	$612	$704	$809	$930	$1,070	$1,231	$1,415	$1,627	$1,872	$2,152
Gross Profit		$0	$0	$0	$0	$0	$0	$2,300	$2,645	$3,042	$3,498	$4,023	$4,626	$5,320	$6,118	$7,036	$8,091	$9,305	$10,701	$12,306	$14,151	$16,274	$18,715	$21,523	$24,751
Compensation		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Rent		200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200
Supplies		0	0	0	0	0	0	250	288	331	380	437	503	578	665	765	879	1,011	1,163	1,338	1,538	1,769	2,034	2,339	2,690
Other operating Expences		0	0	0	0	0	0	375	431	496	570	656	754	867	998	1,147	1,319	1,517	1,745	2,006	2,307	2,653	3,051	3,509	4,035
Accounting		100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
Advertizing		350	350	350	350	350	350	403	463	532	612	704	810	931	1,071	1,231	1,416	1,628	1,873	2,153	2,476	2,848	3,275	3,766	4,331
Earnings Before Taxes		-$650	-$650	-$650	-$650	-$650	-$650	$973	$1,163	$1,383	$1,635	$1,926	$2,259	$2,643	$3,085	$3,593	$4,176	$4,848	$5,620	$6,508	$7,529	$8,704	$10,054	$11,608	$13,394
Taxes		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Income		-$650	-$650	-$650	-$650	-$650	-$650	$973	$1,163	$1,383	$1,635	$1,926	$2,259	$2,643	$3,085	$3,593	$4,176	$4,848	$5,620	$6,508	$7,529	$8,704	$10,054	$11,608	$13,394

Cash Flow
Cash Collected from Revenue		$0	$0	$0	$0	$0	$0	$1,750	$2,763	$3,177	$3,653	$4,201	$4,832	$5,556	$6,390	$7,348	$8,451	$9,718	$11,176	$12,852	$14,780	$16,997	$19,547	$22,479	$25,850
Cash Payments on COGS		$0	$0	$0	$0	$0	$0	$0	$200	$230	$265	$304	$350	$402	$463	$532	$612	$704	$809	$930	$1,070	$1,231	$1,415	$1,627	$1,872
Cash Operating Expenses ETC		$650	$650	$650	$650	$650	$650	$1,328	$1,482	$1,659	$1,863	$2,097	$2,367	$2,677	$3,033	$3,443	$3,915	$4,457	$5,080	$5,797	$6,622	$7,570	$8,661	$9,915	$11,357
Taxes		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Cash Flow		-$650	-$1,301	-$1,951	-$2,601	-$3,251	-$3,902	-$3,479	-$2,398	-$1,110	$416	$2,216	$4,331	$6,809	$9,703	$3,373	$3,924	$4,558	$5,286	$6,124	$7,088	$8,196	$9,471	$10,936	$12,622

Cash Account Balance	$3,000	$2,350	$1,049	-$902	-$3,503	-$6,754	-$10,655	-$14,134	-$16,532	-$17,642	-$17,226	-$15,010	-$10,679	-$3,870	$5,833	$9,206	$13,130	$17,688	$22,974	$29,099	$36,187	$44,383	$53,854	$64,790	$77,412

If an angel offered funding of $30,000 for 40% of your company,how would you view the angelâs offer?

peachleopard847

Please help with the below problem. I don't understand how to solve. Please show work and steps so I will understand.

Apply cluster analysis to the numerical data in the excel file credit approval decisions. Analyze the clusters and determine if cluster analysis would be a useful classification method for approving or rejecting loan application.

Modified Credit Approval Decisions

Homeowner Credit Score Years of Credit History Revolving Balance Revolving Utilization Decision

1 725 20 $11,320 25% 1

1 573 9 $7,200 70% 0

1 677 11 $20,000 55% 1

0 625 15 $12,800 65% 0

0 527 12 $5,700 75% 0

1 795 22 $9,000 12% 1

0 733 7 $35,200 20% 1

0 620 5 $22,800 62% 0

1 591 17 $16,500 50% 0

1 660 24 $9,200 35% 1

1 700 19 $22,000 18% 1

1 500 16 $12,500 83% 0

1 565 6 $7,700 70% 0

0 620 3 $37,400 87% 0

1 774 13 $6,100 7% 1

1 802 10 $10,500 5% 1

0 640 7 $17,300 59% 0

0 523 14 $27,000 79% 0

1 811 20 $13,400 3% 1

0 763 2 $11,200 70% 0

0 555 4 $2,500 100% 0

0 617 9 $8,400 34% 0

1 642 13 $16,000 25% 1

0 688 3 $3,300 11% 1

1 649 12 $7,500 5% 1

1 695 15 $20,300 22% 1

1 701 9 $11,700 15% 1

0 635 7 $29,100 85% 0

0 507 2 $2,000 100% 0

1 677 12 $7,600 9% 1

0 485 5 $1,000 80% 0

0 582 3 $8,500 65% 0

1 699 17 $12,800 27% 1

1 703 22 $10,000 20% 1

0 585 18 $31,000 78% 0

1 620 8 $16,200 55% 0

1 695 16 $9,700 11% 1

1 774 13 $6,100 7% 1

1 802 10 $10,500 5% 1

0 640 7 $17,300 59% 0

0 536 14 $27,000 79% 0

1 801 20 $13,400 3% 1

0 760 2 $11,200 70% 0

0 567 4 $2,200 95% 0

0 600 10 $12,050 81% 0

1 702 11 $11,700 15% 1

1 636 8 $29,100 85% 0

0 509 3 $2,000 100% 0

0 595 18 $29,000 78% 0

1 733 15 $13,000 24% 1

New Data to Classify

Homeowner Credit Score Years of Credit History Revolving Balance Revolving Utilization Decision

1 700 8 $21,000 15%

0 520 1 $4,000 90%

1 650 10 $8,500.00 25%

0 602 7 $16,300.00 70%

0 549 2 $2,500.00 90%

1 742 15 $16,700.00 18%

THEO 100 Lecture 9: THEO 100 - Lecture 9 (1)

Get access

Related Documents

THEO 100 Lecture 7: THEO 100 - Lecture 7

THEO 100 Lecture 6: THEO 100 - Lecture 6 (1)

THEO 100 Lecture 8: THEO 100 - Lecture 8 (2)

Related Questions