Cash Budget Model.xlsx - Crystal Ball Data Workbook...

This preview shows page 1 out of 29 pages.

You've reached the end of this preview.

Unformatted text preview: Crystal Ball Data Workbook Variables Name: Value: Last Var Column Worksheet Data Last Data Column Used 0 2 Sheet Ref Err:509 Err:509 Sheet Guid 6c733c0c-a26e-432d-b2e0-02bb78706d82 8da0f6f0-1c3c-483a-b13a-7d05149be939 Deleted sheet count Last row used 31 34 Data blocks CB_Block_0 CB_Block_0 㜸〱敤㕣摢㙦ㅣ㔷ㄹ摦㔹㝢搷㍢扥挴㙥散愴㑤㉦㜸〱敤㕣㑢㙣㈴㐷ㄹ㥥ㅥ㝢挶搳㝥慣㥤戵㜷㤳捤㘳攳㍣㐹昰㙡戲捦㈴慢㘸戳昱㈳ Decisioneering:7.0.0.0 Decisioneering:7.0.0.0 CB_Block_7.0.0.0:1 CB_Block_7.0.0.0:2 㜸〱捤㔹㕤㡣ㅢ搵ㄵ昶ㅤ㝢㘶㍤晥挹扡㈱㈹〴㘸 㜸〱慤㔸〹㤴ㄴ搵ㄵ敤摦㌳搳㌳㌵㈰㤴㔱㘳ㄴ愳愸㐳㡣㐷㌲㜴搷搲摤攵㜱搴㤹 Decisioneering:7.0.0.0 Decisioneering:7.0.0.0 CB_Block_7.0.0.0:1 㜸〱敤㝤㜹㝣ㅢ搵戵扦慥㙤挹ㅥ挵㠹〵㈱㐰㈰㠰〹〹㑢〳㐹扣摢㐰㥡㌸捥收㤰 Decisioneering:7.0.0.0 㤳捤㘳攳㍣㐹昰㙡戲捦㈴慢㘸戳昱㈳摥㌵昱挶摥ㅤ敦㐶㈸ち㐳㝢愶摡敥㙣㍦㥣敥ㅥ敦㍡ㄱ攴〱〷挴㑢㐲㥣㠸㄰〸〹㐵㜰㐱ち〷㐴㈰摣㌹ ㄰ 挴㈹㌷㐴 ㄴ愳愸㐳㡣㐷㌲㜴搷搲摤攵㜱搴㤹〶㜴㄰挱㠰捡㜱愳慤攵搷㑣㙢㉦摡摤㠳㠳ㄱ㠵㠰㐶㡤㐴㤳㠸㐹搴〸〹㥡㈰ㄸ㕣昰攰ㄲㄵ攲捡㔱㠳ㅥ搷㐰㌴ ㈰㠰〹〹㑢〳㐹扣摢㐰㥡㌸捥收㤰㤰挵〹㤴戲ㄸ㔹ㅡ㈵ち㕡㠲㈴㠷ㄸ㘸ㄳ〸晢㔶㤶ㄴ捡㥡つ㈸㌴㉤㕢㘹㈹㘵㉤换愳㐰㈸㄰㘸㈹戴㤴戶㠱㔲昶 ㄰〸〹㐵㜰㐱ち〷㐴㈰摣㌹ ㄰ 挴㈹㌷㐴戸㜰〱愱㤵戸㜰ぢ摦㔷搵㍤搳㌳攳㘹㝢㈷〹捣㈲㤷搷攵敡慡扦慡慢敡㝦搶晦㔷㙦㐶换㘴㌲ㅦ㈳昱㉦㔳㍦ 㥡㈰ㄸ㕣昰攰ㄲㄵ攲捡㔱㠳ㅥ搷㐰㌴敥挶㠵愳㐴㡤挶戸攵摤摦搵换㌰㔵㠳㥥㤳㠲㝥昳晦㝢昷摤㝡昵晦㝢慦㝦㔷㠸㠵㐲愱慦攸挲㕦㕣捤ㄸ散㌳ ㈹㘵㉤换愳㐰㈸㄰㘸㈹戴㤴戶㠱㔲昶搰搲昶搱〷攵昷晤㥥㤹搱捣㐸㈳摢攴挱攷挷ㅦ㙦ㄲㅤ摦㜳敥昷㥥㝢敦㌹昷摥㤹扢㘸攴㔳㍥㥦敦㌳㕣晣换慢 敡㝦搶晦㔷㙦㐶换㘴㌲ㅦ㈳昱㉦㔳㍦ぢ㜷㤷戶㠲㔰㌸挵㔹捦戶㐵㈵戴㍣㌷㈸㑥晢扥戱戵㘸〵㘱ㅦ〰昲㘵ぢ敤㐱慥ㅣ㔸慦㡡㐲㜹㔳昸〱㠰㜲㤹 㝢慦㝦㔷㠸㠵㐲愱慦攸挲㕦㕣捤ㄸ散㌳㝢㝥愹捣㜳㥤愹㐲㌶换敤㜲愶㤰㉦㜵㜶ㄷ㡢收晣改㤹㔲戹㠹〰㤱㜴㠶散愵㤶㜴㈹㜳㉥㙦㑢捦攳挵ㄲ㠱 敦㌹昷摥㤹扢㘸攴㔳㍥㥦敦㌳㕣晣换慢㠲㠱㔱㕤㝤搹㥣㥥ㅣ摦㤱㑥㈴昴㐸㉥㥥㑥㘵挷户㘷㌲攱扥㌹昱㙣慥ㅣ㠰㐰㜷ㅣ昱㔹㝦㜷㌶㝥慡㕥搵扤 ぢ敤㐱慥ㅣ㔸慦㡡㐲㜹㔳昸〱㠰㜲㤹㑣愱愰㘷搱捥㐱昸㍢ㄶ㍦攸散㌵摣㡦散搲散捣搲敡换ㄸ戵ㄴ㝡扥㌸㌲㜹㐵昵㍤昳㐴昱㐴昱昴攳㐷㡢㐷㡦 㜴㠶散愵㤶㜴㈹㜳㉥㙦㑢捦攳挵ㄲ㠱㕡㐲愱戶㌶㈹㑣昶㔱摥㐷慥㑥㈴㜸㐹捤㄰㠴ち㐹ㄱ㠸㔶㠸㌶〸〹愲ㅤ〲㥥搲㘸㠸㕤㐸㡣ㅥ㐳㘲㔶慡㘷愶㜵 慥ㅣ㠰㐰㜷ㅣ昱㔹㝦㜷㌶㝥慡㕥搵扤㐲捦㘴〱昲晢㝣㔵㔵㕡ㄹ攲㐷㥡㥦㤰挵㘸㑣愵㔵㤰〰攵搳〲㈴㤵㈴㔵㈴ㅡ㐹㤰㘴〸㐹㌵挹㔰㤲㘱㈴㌵㈴ ㌲㜹㐵昵㍤昳㐴昱㐴昱昴攳㐷㡢㐷㡦㑣捥搶散戰收㡢㌳慥愸㠵扥㘱ㅦ㤹㕣慥慤摡㔶攵㌹戱戵攲㕤ㄵ敥ㄹ戱㝡昴挴慡㜱昲挹㘳㈷㑦㥤㌲㑦㥦㝥 〲㥥搲㘸㠸㕤㐸㡣ㅥ㐳㘲㔶慡㘷愶㜵〶挵㌱扢㕣㈸昲㠹攳㑦慣摣慤㉢搱愹㜶ㅡ昱㘸㘷㜴攲昸搴㐰戶㍣㔰攴㕤㜹㍥㔰㉥㥡搹㠹攳㡦ㅢ戰戲ㄹ晢 ㈴㔵㈴ㅡ㐹㤰㘴〸㐹㌵挹㔰㤲㘱㈴㌵㈴㈱㤲㥤㐸㜶㈶ㄹ㑥戲ぢ挹〸㤲㕤㐹㜶㈳搹㥤㠴昹㙢㝢㤰散〹㔲㍤ち㘴㘱挷搴㜹㍤换㔰㥢慥㕣㍡愳ㅦ㕣㝢 ㄹ戱㝡昴挴慡㜱昲挹㘳㈷㑦㥤㌲㑦㥦㝥㜲ㄸ㉦捥㉣捥捥㉣晢挲っ㍥㤵ㄱ㜳㥣敥挹㌹㔱戱戸㉥㈱㝣换㕤㉢捥捥攰㕦㘲敥㜸㝡愲㔸㕡ㄷ㈲攴㡢㠵 㔰攴㕤㜹㍥㔰㉥㥡搹㠹攳㡦ㅢ戰戲ㄹ晢ㄸ㍥晦昸挲㤹㍣摦挵慤愸㙡㤹㕡㌲愶改扡㙢ㄸ挹ㄶ㠴愳㑣收㜶〶㜱㜳㕥捣攴晢㍡㔳㍤昴扦攱㑥㌴㑢搰ㄲㄴ ち㘴㘱挷搴㜹㍤换㔰㥢慥㕣㍡愳ㅦ㕣㝢㤴㔱收㐹㉤攳ㅢ挶户㌵㑦ㅣ㍦昱攰摡㡥摥㐴慥㌷愳㑦㑡改扤戹㑣㌸㜱㜰敤晣摥㥥㐴㍣㜲㠴摥户㈸㝤㤲㥥 捥捥攰㕦㘲敥㜸㝡愲㔸㕡ㄷ㈲攴㡢㠵㉦摣㡡〸㜴㜴ㅣ㜲愶㠳愰收㙣㜰攳㜴㘷ㅥ换慣ㄸ㐱㤸㜳㘶㠵㙤敢㑥㍣㙡挱㔹挲扥搹挶搶戰㔳ㄲ㙥㘰㠵搶 㜳㕥捣攴晢㍡㔳㍤昴扦攱㑥㌴㑢搰ㄲㄴ㡢㍣㙢㘲つ㘶㜱ㄷ㜱敥㤵敢㉥㤵〶㜲㘷㐱ㄵ㥢㔳㈸㥥㔹敡攷扣㝣搴㐰挶㤱ㅢ㉤㔰㌴㐲㤵㐰愸〲攸攸㕣 ㌸㜱㜰敤晣摥㥥㐴㍣㜲㠴摥户㈸㝤㤲㥥㥡愴昷㑣㙣攸〹㌷戶搶㌵㌶㌵挵摡摡㕡晤慣㔴晤㌴㍤ㄲ㘷敤㜵㍤ㄳ㑦㉤ㄹ摦㌱ㄵ晦ㅤ㌹㠱㙢㠱㈱㌳ㄹ㍤ㄱ愶 㑥㍣㙡挱㔹挲扥搹挶搶戰㔳ㄲ㙥㘰㠵搶愶ㄵ㙥攵㥤ㄵっ㔴ㅤ㜱㉥〷攲㤲攱慥㠹攷つ㐷攴㥣㜳㌵慢摡慦㔲愶敦㜳昱㄰挹㠹挹挵ㄷ愷〳㘷㜶摤昰攵㡣 搴㐰挶㤱ㅢ㉤㔰㌴㐲㤵㐰愸〲攸攸㕣慡挰㕤㌷㘳㘷㜸扥扣㠷㌷愱昸㘸㐶昷愵㈷㍥扥㌰㈶㌷㘵搰收搹ㄴ捦㘶㐹㔵摡㈵㜷㐲㠹捦㌲昳㝤㝣㠶㤹攳 㑦㉤ㄹ摦㌱ㄵ晦ㅤ㌹㠱㙢㠱㈱㌳ㄹ㍤ㄱ愶㈵ㄷ敡㌱搶㜶㘴戲㍤㥢敤㑤㉥愷愸敥攸㜴收愴散㔲㕤捦捤散㡤㐷㐳捥ㄸち㥣搰晡㤲搰㝡㐲慢㤳ㅤ㘹㍤ㄶ㡢 敦㜳昱㄰挹㠹挹挵ㄷ愷〳㘷㜶摤昰攵㡣〲㙥㑢ち散扣㕦㘹㠶㝤愰昳戸㥣扡㝣〳挷㝣愸㌳ㅣ㕡慥ㄸ㝥ㅤ㜲慡㌳㘴戴昸收ㄹ㍣搶ㄹ㍥戱㐷捤㝤ㅥ敤摣 㘶㐹㔵摡㈵㜷㐲㠹捦㌲昳㝤㝣㠶㤹攳㉤㌹戰㌴搱ㄵ㘲捤愱愶㔱摥づ㐲昹㜵挶㤱搸搷㔹㡣㈱昷挷搶戰㐶㙥㈸㥡晦㐵戹搴愸挴㝥㠶搳㘶㌸㙤㠵 㐳捥ㄸち㥣搰晡㤲搰㝡㐲慢㤳ㅤ㘹㍤ㄶ㡢㐷攲㝡㉡㌷挲㘴㔰㍥㜰挸ㄷ㌵㕥㤴ㅥ㤶㥣扥㌲愲㈷㍡昴㐴〲愲散搰攴攲慣扥㌰㥣㕡愲ㅦㄹ㑥敡晥㈴戵㤴 ㌳㘴戴昸收ㄹ㍣搶ㄹ㍥戱㐷捤㝤ㅥ敤摣㐷㙥㘵㌳戴㌶ㄴ搱戶摣㔱㉣㐶捦㌳ㅢ㘰㔶㘰㐶〴敡㠳捣㠶㤸つ㈳搳晡晦〵づ㐹㜶㘴㔳戶㙣㘴换慢搹㜲 㙥㈸㥡晦㐵戹搴愸挴㝥㠶搳㘶㌸㙤㠵搳㜶㌸敤㠴搳㍣㥣㜶挳改扥㜰扡㍦㥣捥㠴搳㘷㠴搳㘷ㄲ愶㝡戵戵戶㠶扤㙢晢挷㉢㤶ㅥ戶捦愱㐷摦㝡攸㠲 搰攴攲慣扥㌰㥣㕡愲ㅦㄹ㑥敡晥㈴戵㤴攳昲愹ち㕦昹㄰戳ㅤ㔰㌸㤸㜰愰㙥㌰挶㜰攵㑦搷㈸愷㙥ち㉡戶愱㐵㍡㠵㙣ㄵ㘵摤攱戲敥㥥戲敥㐸㔹㜷戴慣 搳晡晦〵づ㐹㜶㘴㔳戶㙣㘴换慢搹㜲㈵㕢慥㘶换㈲㕢㌶戳攵戵㙣㜹㍤㕢戶戲攵㤷戳攵慢㠰㠹㔳㘱㘰㈰ㅢ愵㝦㝦昷攲搶戱愷摦㥦㜹敢敡敦晦㌲ 㠶扤㙢晢挷㉢㤶ㅥ戶捦愱㐷摦㝡攸㠲㤶摤慦㜹摢㘰摢㠹ㅢ晣㕦㍣攵挴㥡ㄶづ㑥㕢改ㄶ㍡㕢晢昷㕢挹摥昷っ挳㍣摥昳っ昳㤴㌷扡愳愷㙥㥦㜹捦㌹ 㠵㙣ㄵ㘵摤攱戲敥㥥戲敥㐸㔹㜷戴慣㕢㉦敢㡥㤵㜵㉦㈹敢㕥㕡搶ㅤ㉦敢㕥㔶搶㝤ㄲ㌰搶㔵㔵㔹㔹㘶㕥摢晦戹晥攲挳㐷ㅤ㍡敢捥㐳扦攵摦攵摡户摡 愵㝦㝦昷攲搶戱愷摦㥦㜹敢敡敦晦㌲戹昸收㠷挳晢〰㜴㌱㥡搴㥣㙦㕣〳愹㌵㘸昸㜸ㄱㅣ戱ㅢ㥥〰㑢㤸愷捣㈷捣㘳挷慡愷㡥ㅡ㈷㡣ㅣ㤷㤵㠲 っ挳㍣摥昳っ昳㤴㌷扡愳愷㙥㥦㜹捦㌹戱搴愴㘳收扥㔱扤㕢㘴㌷ㅡ㡤敦㍡攸㤴㤴㔹敡ㅦ摦㌳攰昴昱㜲攷㘰戶㜴摡㙣散㘹散愰晤㍢㡥敥㔰㌵㘹㜷 晦戹晥攲挳㐷ㅤ㍡敢捥㐳扦攵摦攵摡户摡搴㥦愱㥢晡慦敤㍣㌶扢㜶散㉤㔳㌶晦晤搵㌳㐶㌶㍣晡㡡晡㤳ㄹ㔱㤴攲㡦㘶挴换㉦摦㔲㜹挳换攵㥤户晤昲 愷捣㈷捣㘳挷慡愷㡥ㅡ㈷㡣ㅣ㤷㤵㠲晣㈶㐲ㄹ〳散戰昹㠲攵㔶扤㙢ㄲ㜷㜷捦ㄸ㠱㘸㙣摣㔴搴㌶攳搵摣㙡㜰搷昶㡤愵搰〸挵㥤慤㙤㡤㐱摡扡 㘰戶㜴摡㙣散㘹散愰晤㍢㡥敥㔰㌵㘹㜷攰搹扢ㅥ㔹晦㘵㑢㔷敢捦慣㥦㜶敦愳㑢㜲晢㝥㐷㝥㠹搶㍢ㄴ㐲㐲戱㜷㠲攲㜸摢㌳㕣㜴㙤攴㠶ㄳ㤲慤搳ㄶ 㤴攲㡦㘶挴换㉦摦㔲㜹挳换攵㥤户晤昲㡣昶愷搶晤昲ㄳ㉢户挰扥〸搵㑥㍡攰搸㡥㜰㜶㘹敤搴摥攸ㄲ㍤㌷㝥㘵㈲㝣ㄷ㝤㕡㜷挰扥㘳㍡挷㌴㌴㙢 㙡㜰搷昶㡤愵搰〸挵㥤慤㙤㡤㐱摡扡㤵挰㔶㈲㤰敦㍢摣摡敤㡡㘱搷挴昴㜵㑢㌵摦搳搲散㉣晢摥㙡攷搶㜹㕦扣㔲㙦㙤㥢搱㌴〴摡愶ㅣ扢㙤㤵慡 戱㜷㠲攲㜸摢㌳㕣㜴㙤攴㠶ㄳ㤲慤搳ㄶ㍦㝦攸挰昸㘳昳ㄳ搹㕢㐱ㅥ晦昴っ㠱㤱敦㑤㌷摣㔹攴㡡㌴㡥㔰㈱昶扡㐷㜶㔲挷扢摢攷ㅣ㤹㥦戶㙣敤ㅤ㌷ 㘵㈲㝢㝣ㄷ㝤㕡㜷挰扥㘳㍡挷㌴㌴㙢愳㠹㔷慦㥡捡慥㝣攳敥㤹㡦愹攸昴敢搳㌳㐷慥㝢扣㝤户敡㌱㠸㥤搳㌱㜵㝥〶㕥昹㐲㥡㘷昵㔸㙡㥣㠷〶 㕦扣㔲㙦㙤㥢搱㌴〴摡愶ㅣ扢㙤㤵慡㐹捤㙢㜲㜶摤ぢ㠴㉢愷㌷攵㉣㕢㤵慢挲㉦〹㡡㐳㔱㤵㑢㍤挰愶㠸敢愷㤶㕣㉣ㄴ摣㕡扤㍦㔹㙢㍥㝢㍤〴㌳㡢 昶扡㐷㜶㔲挷扢摢攷ㅣ㤹㥦戶㙣敤ㅤ㌷㕦晦愶搳捤㔰㡢㈲昲搷㠲攲㜸搵㌳っ㡢晣㤵㈰㡦㤷㍤挳㤶㉤慢㕡慦摢搲搴扢㜶搳愲敥㐷㤷㙦晡ㅣ㤱攰㡡 搳㌱㜵㝥〶㕥昹㐲㥡㘷昵㔸㙡㥣㠷〶㜹愴㥥晢㘲㌴敥て㡤㜳㍢愶㑥㑢㈷挳昱搴ㄷ愲搲捦㌱愱㘱㌰捤㘶〶扡㙤㈴㥣捤㤹㉤㤷㠳㐷㜵㤲搶搲㌳㝡 敢愷㤶㕣㉣ㄴ摣㕡扤㍦㔹㙢㍥㝢㍤〴㌳㡢㉡收扢㈱晣㜰㙢挵㔸戵挵挱㈶㄰昵㑥㌴ㅣ㙡慡㥥昷㉡戵㘰搶㜳㐳摦戳㥢㕢愶慢㥢〶㈴㑤昵㠲㔷ㄵ晤晤ㄹ 摢搲搴扢㜶搳愲敥㐷㤷㙦晡ㅣ㤱攰㡡散㑦㘲挴挸㝢㍢㔴㐵㍡〰㔸昶愲㐷昶搰戳㜳ㄶ挴ㄷ㝤㌲㜵改㜴攳〲㘹昰挲㌹っつ㐴㐴晥㐲㔰ㅣ㝦昷っ㤳 扡㙤㈴㥣捤㤹㉤㤷㠳㐷㜵㤲搶搲㌳㝡㉡愲㘷ぢㅡ㜶㔵昲愸㜰㠶㙤扡㠲㠱㥡愴搱㈵㍢愳攸ち昱㕣㥦㔷戳慦愸㔰ㄵ㘸昴〷㜸ㄵ㐶扣㌲㝥㐶㈶搲戱 摦戳㥢㕢愶慢㥢〶㈴㑤昵㠲㔷ㄵ晤晤ㄹ㈹ㄴ㈰㙣晢晡㌴㉤昳昹捥扣㈰ㄱ㤱㐰㌱ㄹ昹㡥㘶戲㉢㕥挲敡戰ち㕢㤰㈶戳て敥㌰ㄸ攷㉢㘵㑣ち〷㈶搶 㘹昰挲㌹っつ㐴㐴晥㐲㔰ㅣ㝦昷っ㤳㡡㝢扤晦昱て摡㔳㙢摢㙦ㅢ㍢敦挶挵㙢搸搶㈰㡦㉤㥥㘱挷晣㔲挵昵摡ㄱ㤱敦敦㉣昲㈹ㅤ慡㉡ㅤ㉣㈲㝦捥㈳扢 慦愸㔰ㄵ㘸昴〷㜸ㄵ㐶扣㌲㝥㐶㈶搲戱㌴㥣挹〹㐷㝦敤㔸㝢慦㉤挸㠱㉥敡㡡㈷㡦搰㌳㈹㍤挱㑣攸戸㜱〵㈰ㄹ㔷っ挳攷〷ㄸ慢㌶㜴㑢㔱㈷搲づ 㕢㤰㈶戳て敥㌰ㄸ攷㉢㘵㑣ち〷㈶搶㐴摤挱㤷㍥戲挳戰㜵捣㝤戶挰搹散㜸戴晡㘷㌷㠵ㅢ㥥㌷摣慡㉤晣㔴捤愷㜱㐶晡㈸戲摣つ〸㠴㡥扢㐷㌵愷 昵摡ㄱ㤱敦敦㉣昲㈹ㅤ慡㉡ㅤ㉣㈲㝦捥㈳扢㜲搳㘱㘳㔶㕤㜸挴㤴㙢㕦昹散戱㑤捦慦摣挶搰昵㐴攴捦〶挵昱㡣㘷ㄸㄶ昹搳㐱ㅥ㑦㜹㠶挰㙣㤹戴戳挸 ㈰ㄹ㔷っ挳攷〷ㄸ慢㌶㜴㑢㔱㈷搲づ㠰㔴㍢㄰㈴㜰㄰挸挸戹改㔴㙥㘹㙤㜳㙤㤷扥ㅣ㘳㜷㡦㥥愹㥤ㅡ㑥㠴㘱㌹敤㙢〴㡥〳㔱敡㐵戳㜵㑥㝤敥㡥扢 㔴捤愷㜱㐶晡㈸戲摣つ〸㠴㡥扢㐷㌵愷㕤搷戶㜲搷慣㙡戸㥥㕦ㄷ搶摡㝡㠸㍡㘸挷㐲㠱㕢摢㤶昴摢㔰愵敦㘷㌶㡥㙣㜰㌰㤳㥦㈰㔰㝥㄰㈹㤳愳㜴㑡 㘷ㄸㄶ昹搳㐱ㅥ㑦㜹㠶挰㙣㤹戴戳挸㈹捦㔵㈹㉡㈲㝦挲㈳摢晢㤶捤㑦㕣昱搲戲㈹㝦晡搶搳攷㕤晡敤㡤㥣愱㔵㡢挸㌷〷挵昱㔷捦㌰㉣㕢ㅥて ㌹敤㙢〴㡥〳㔱敡㐵戳㜵㑥㝤敥㡥扢摥㝣晥㡣昶戳㜶摢㜶昶摣户收ㅤ攷攷愸摤攴㔵愴挲愱捥ㅥ搶㑣㐷挹〰㥦㥣㤶捤捤て㘷㤲搹㉦搶㘵㜰搸㐰 㘷㌶㡥㙣㜰㌰㤳㥦㈰㔰㝥㄰㈹㤳愳㜴㑡攱攵㈶㐱捥㝥㑤扣㍣㙣捥㕢㜶㈸㤴㔰ㅥ㌵㠱ㄱ愵搵㈴晡㐶㐸愲扥㔱㔱ち㘳挲㥣〵㤵ㅡ㤶ㅢ㙥㌵昸戶㡤㑢 㥣愱㔵㡢挸㌷〷挵昱㔷捦㌰㉣㕢ㅥて昲㜸捣㌳摣晦改㠱户㍥㍦愳㙦收㑤㙢㝢攷ㅥ摣捤㘶㈱ㄲ㕣㤱㌸㠹ㄱ戳㘵㉡戲㈵〱㉣摢攴㤱挹ぢ㑥㝥昸㝢 〰㥦㥣㤶捤捤て㘷㤲搹㉦搶㘵㜰搸㐰㍥㙢捦㈶扦㝣㥦㈱㤳㉦挴㘷㠱㐳㘰收㝤㡥㑣㘷㤲戸晤捣搵挳愹㐹㉤ㄳ㜹ㅤ摣㤵㡢㑥搳㔷ㄸ㥣㌶㥥晥㥡〰ㄲ 㔱㔱ち㘳挲㥣〵㤵ㅡ㤶ㅢ㙥㌵昸戶㡤㑢ㄴㄱ敤挹㠲㥥㤳〵ㄴ〵捤昲㈰㠵搷㐰㌴㉤搲㈰ㅤ㌸㐱㐴㘴ㄴ捤㡥㤱㥢㠹㡣昰㈹㌲〲昰㐹㈲㈴昴搱捥㌲ 戳㘵㉡戲㈵〱㉣摢攴㤱挹ぢ㑥㝥昸㝢昳㉦㤹㜱搵〷㘳㍦㝣扣戰㙡㈳㐳摦ㄶ㤱㍦ㄲㄴ挷挳㥥㘱㔸攴て〵㜹㍣攸ㄹ㜶捣ㄶ㐴㠲㉢搲㐵㘲挴挸㈹㕢ㄴ ㄳ㜹ㅤ摣㤵㡢㑥搳㔷ㄸ㥣㌶㥥晥㥡〰ㄲ㤸挸㔰㔷㌸愱㘷㙢攷㠶晢戴㍡戲昵㈰㑡㍤㘳㍡㜲㐲㘶攴 〷晦㍣㈴搸㜱㕢昰慥㥡ㄵ户慥搹慣㜸攷攵㝤㑢㙤 ㌱ 㤱㥢㠹㡣昰㈹㌲〲昰㐹㈲㈴昴搱捥㌲㠲挴摥㑥愴散搴㤱ㅦ昷愴搹㜶㜶扣㤲㘶〷戰㜱晡㐱㘶户㌳扢㠳搹㈱㘴摡摦㈰攱㈸攵㔰㙥㑥晡㕤㜸搶敦 ㍣攸ㄹ㜶捣ㄶ㐴㠲㉢搲㐵㘲挴挸㈹㕢ㄴ改㜰㘰搹㕦㍣戲㔹愳戶㕤㜲㜹挷慥㍤ㄷ捦㍦㘱散㡡戹㥢摢ㄹ扥ㄴ㐵攴ㅢ㠳攲搸攰ㄹ㠶㘵换㝤㐱ㅥ昷㝡㠶 㕢昰慥㥡ㄵ户慥搹慣㜸攷攵㝤㑢㙤 ㌱ㄱ㐵挳摤搳㘶挴愷㕢愳㜵攵慢㔷捥摥ㄴ㑢㡦慦㕣扡捦㈶昵㔴愹ㄴ㑦㥡ㄱ㈵ 〷挸㔶㘴 ㌸搰 〰搹愸戵 〱攵 ㈱㘴摡摦㈰攱㈸攵㔰㙥㑥晡㕤㜸搶敦㘶㜶て㌲挸㈷㥤㌲㈷ㄲ㔵戴愱㜶㘳㐷ㄲ㙥〴㜶戲㌴㡡㤵㈸愲㘵㕣户㌳㐷ㅣ㠹攸挸敡散つ㕤摢㉦㜵散挳 攴ㅢ㠳攲搸攰ㄹ㠶㘵换㝤㐱ㅥ昷㝡㠶㙢㝡㑦㈹㕤 ㌹㘱搵㤱㙢㍥㝣㜱搱㕥敡 〳㕢ㄱ〹慥挸㘴ㄲ㈳㐶㝥ㄴ戲㘵ち戰散㙥㡦㑣㔶晦扤搵㝤昲搴愹ぢ 㑦㥡ㄱ㈵ 〷挸㔶㘴 ㌸搰 〰搹愸戵 〱攵㔳晦㘵㉡㝢㜷搶㤶摤㡦㝤戴㘱摡收昵㙢て扤㘲搶㠴㑦ㄵ㝢扣㍣㐱ㅣ㠶㠰㜶 ㌸㐸㘰ㄲ挸慥㐶挳㙥慡㙤敦㕤 户㌳㐷ㅣ㠹攸挸敡散つ㕤摢㉦㜵散挳㥤㘹㌳戹ㅣ㔲㘴ち㘸㜲慤㍢㠰㈶㌷㠲愰㕤敡慤㝢搱㔵㥦㘴㜶ㅦ㌲愵㔸㘸散敥捥㥡愷㌹㜹㑢㤸㐴捡㄰敡㔲戹 戲㘵ち戰散㙥㡦㑣㔶晦扤搵㝤昲搴愹ぢ㝦 ㌷昸攰㡡㍤敦扡㤸愱昳㡢挸敦ち㡡攳㑥捦 ㌰㙣捤敦〸昲㔸敦ㄹ 〲㈳㍦收㙢㐴慥㐸搳㐵攴敢㍣戲㤷敦扢 㠶㠰㜶 ㌸㐸㘰ㄲ挸慥㐶挳㙥慡㙤敦㕤搲㥢捤攵㕢昵搷㠹㥡っ愲搴挳愶捡㝦扤㕥㝦㘱㔷摤㤴昶晢ㄶ㝣扤㙤挴㤵㡤㍢㉢戶㑤戶散㐰㍢㠸换敥㑤㉥ 㔸㘸散敥捥㥡愷㌹㜹㑢㤸㐴捡㄰敡㔲戹㐷㐴㑣昳㍦㐵挰戵ㅤ㕤昶散㘷㥡㠲㔳收㉤㙦㍦ㅦ改捣摢ㄱ搲㕢㜴收㥥捥愱㥦攸㈶㉤攸晢挱㕥摡㥦㍢敡㤷 〷 〲㈳㍦收㙢㐴慥㐸搳㐵攴敢㍣戲㤷敦扢扤 ㌷戳攷挲㤹㔷挴扥摢昲改敡㜵慢ㄹ㡥ㅦ㈲昲摢㠲攲戸搵 ㌳っ㕢昳㕢㠲㍣㙥昶っ㠱㜹㡥㡣ㅦ㜱捤㈹捦㔵 㙤挴㤵㡤㍢㉢戶㑤戶散㐰㍢㠸换敥㑤㉥扢ぢ愷㑤 〵㐸敢㈰㝣ㅡ㐸攵扣㐸㉥㡤㙥愴㑤愷㜸 〶㠸㔲昷㤶 ㌰㠴攲㉤㕦 ㌲㥡㠵㠰㉢愳㘶㔷㐶挲㘹㥤搴 㥥捥愱㥦攸㈶㉤攸晢挱㕥摡㥦㍢敡㤷 〷搱慣㍦挴散㘱㘴㉤晡㠵㈷敦㥢昵ㄲ㐸㤳搸㐹㘰㙥㍦㍤㉥搲挲㕤搹摡㄰㔲晢っ㥢㉢㠶扦㈶㐲㜸㉦ㄶ收㘰 〷㝢 昳㕢㠲㍣㙥昶っ㠱㜹㡥㡣ㅦ㜱捤㈹捦㔵㘹戶㠸晣㈶㡦㙣搹攱て昵敦挶搶捣戸㘷挳㐷㔷敦扢攰散㉥㠶 ㌳㤳㠸㝣㑤㔰ㅣ慢㍤挳戰 ㌵扦 ㌱挸㘳㤵㘷 攲㉤㕦 ㌲㥡㠵㠰㉢愳㘶㔷㐶挲㘹㥤搴 ㌸ㅢ㈴㜰 〴㐸㡤攱攰㝣扦搵收 ㌰㝡㉥㠸㔲㜷㤹ㄹ慥愸㝦愳㝤攲㜱摢攷摤㝦㑡㕤挷㠴㈳㑥㜸㐳昱㘱㑡㡣 Cash Budget Model Desired Minimum Balance $ 100,000 February March April May $ 400,000 $ 500,000 $ 600,000 $ 700,000 Sales Cash Receipts Collections (current) Collections (previous month) Collections (2nd month previous) Total Cash Receipts 20% 50% 30% $ 120,000 $ 250,000 $ 120,000 $ 490,000 $ 140,000 $ 300,000 $ 150,000 $ 590,000 60% 12% $ 420,000 $ 72,000 $ 10,000 $ 30,000 $ 20,000 $ 480,000 $ 84,000 $ 10,000 $ 30,000 Cash Disbursements Purchases Wages and Salaries Rent Cash Operating Expenses Tax Installments Capital Expenditure Mortgage Payment Total Cash Disbursements $ 60,000 $ 552,000 $ 664,000 Ending Cash Balance Net Cash Flow Beginning Cash Balance Available Balance Monthly Borrowing Monthly Repayment Ending Cash Balance Cumulative Loan Balance 100000 $ (62,000) $ 150,000 $ 88,000 $ 12,000 $ $ 150,000 $ 100,000 $ - $ 12,000 $ (74,000) $ 100,000 $ 26,000 $ 74,000 $ $ 100,000 $ 86,000 June July August September October $ 800,000 $ 800,000 $ 700,000 $ 600,000 $ 500,000 $ 160,000 $ 350,000 $ 180,000 $ 690,000 $ 160,000 $ 400,000 $ 210,000 $ 770,000 $ $ $ $ 140,000 400,000 240,000 780,000 $ $ $ $ 120,000 350,000 240,000 710,000 $ 480,000 $ 96,000 $ 10,000 $ 30,000 $ 420,000 $ 96,000 $ 10,000 $ 30,000 $ 30,000 $ 150,000 $ 360,000 $ 300,000 $ 84,000 $ 72,000 $ 10,000 $ 10,000 $ 25,000 $ 25,000 $ 616,000 $ 736,000 $ 479,000 $ 407,000 $ 74,000 $ 100,000 $ 174,000 $ (74,000) $ 74,000 $ 26,000 $ (62,000) $ 34,000 $ 100,000 $ 134,000 $ (34,000) $ (62,000) $ 162,000 $ (34,000) $ 301,000 $ 100,000 $ 401,000 $ (301,000) $ (34,000) $ 134,000 $ (301,000) $ 303,000 $ 100,000 $ 403,000 $(303,000) $(301,000) $ 401,000 $(303,000) ...
View Full Document

  • Spring '13
  • none
  • Industrial Simulation

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern