Question
Offered Price \$50.00

# FIN415 project1

Question # 00101493
Subject: Economics
Due on: 09/15/2015
Posted On: 09/08/2015 02:13 AM

Rating:
4.1/5
Posted By
Questions:
2
Tutorials:
0
Feedback Score:

Question
You need to analyse given financial data using various Excel functions.

the PPTX in files will tell you the functions you should use in every section.  if you are good at excel, this will be easy for you.
Attachments
Tutorials for this Question
Available for
\$70.00

#### FIN415 project1

Tutorial # 00095833
Posted On: 09/08/2015 02:40 AM
Posted By:
neil2103
Questions:
9341
Tutorials:
13656
Feedback Score:
Tutorial Preview ……
Attachments
1-Project-1--Part-2-_(1).xlsx (1121.51 KB)
Preview: this xxxxxxxxx VIFWellington xxx all other xxxxxxxxx and all xxxxx XFranchise xxx xxx other xxxxx and all xxxxx XOwned_BO and xxx other xxxxxxxxxxxxx xxx all xxxxx XLograthmic value xx Agency CostContinuousIntervalDiscrete/ContinuousLevel xx Measurement1 x xxxxxxxx location,.....
_Part-2_(1).docx (57.09 KB)
Preview: The xxx plot xx given belowFive-Number xxxxxxxxxxxxxxxx 33016First Quartile-0 xxxxxxxxxxxx 116853Third xxxxxxxxx xxxxxxxxxxxxxx 68583From xxx above box xxxxx we see xxxx there xxxxx xx outliers xx the dataset xxxxxxxx regression analysis xxx carried xxx xx predict xxxxxx costs using xxx dummy variables xxx multiple xxxxxxxxxx xxxxx isAgency xxxx = b0 x b2 * xxxxxxxx + xx x Wellington x b4 * xxxxxxxx + b5 x Franchise x xx * xxxx + b7 x Owned_BO + xx * xxxxxxxxxxxxxxxxxxx xxx multiple xxxxxxxxxx output is xxxxx belowRegression StatisticsMultiple xx 2314R xxxxxxx xxxxxxxxxxxx R xxxxxxx 0485Standard Error0 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx FRegression713 63201 xxxxxx 60720 xxxxxxxxxxxxxxxxxxx xxxxx 1836Total1319254 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Errort StatP-valueLower xxxxxxxx 95%Intercept0 30070 xxxxx 81060 xxxxx xxxxx 3763Auckland-0 xxxxx 0336-1 92610 xxxxxx 13080 0012Wellington-0 xxxxx 0330-0 xxxxx xxxxxx 08260 xxxxxxxxxxxxxx 05060 0316-1 xxxxx 1087-0 11250 xxxxxxxxxxxxxx 00610 xxxxx xxxxx 8795-0 xxxxx 0857Rent0 04560 xxxxx 91460 3606-0 xxxxx 1434Owned_BO-0 xxxxx xxxxxx 41020 xxxxxx 2111-0 0569Owned_Family0 xxxxx 02405 75330 xxxxx 09100 xxxxxxxx xxx above xxxxxxx we haveAgency xxxx = 0 xxxx – x xxxxx Auckland xxx 0 0180 x Wellington – x 0506 x xxxxxxxx + x 0061 *Franchise xx 0456*Rent–0 134*Owned_BO x 0 xxxx x Owned_FamilyThe xxxxxxxxxxx of determination xx 0 0536 xxxx indicates xxxx x 36% xx the variation xx the dependent xxxxxxxx is xxxxxxxxx xx the xxxxxxxxxx model while xxx remaining 94 xxx left xxxxxxxxxxx xxx overall xxxxxxxxxxxx of the xxxxx is good xx – xxxxx xx f xxxx statistic < x 0001), indicating xxxx the xxxxx xx good xxx in predicting xxx dependent variable xxx Agency xxxxxxx xxxxxxxxxxx of xxxxxxxxxxx variable Auckland xx -0 0648 xxxx indicates xxxxx xxxx the xxxxxxxx is at xxxxxxxxx.....
part_1_updated.xlsx (592.21 KB)
Preview: MiningPersonal xxxxxxxxxxxx related xxxxxxxxx serviceResidential InvestmentRetail, xxxx purchaseLoan to xxxxxx companyHire xxxxxxxxx xxxxxxx dealer xxxxxxx stocksCommercialProperty loanTansport, xxxxxxx and aviationLeasingPropertycredit xxxxx personalRetail xxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx equipment xxxxxxxxx in small xx medium enterprise xxxxxxxxxxx vehicle xxxx xxxxxxxxxxxxxxxx Finance xxxxxxxx and Business xxxxxxxxxxxxxxxxxxxxxxxxxx property developmentMortgage xxxxxxxxxxx and xxxxxxxxxxxxxxxxxxxxxxxxxxx xxx consumerLoggingsmall xxx medium size xxxxxxxx in Nelson xxx MarlboroughRural xxxxxxxxxxxxxx xxxx (car, xxxxxxxxxxxxx Retail customersconsumer xxxxxxx goodsLoan to xxxxxx companyfunding xxx xxx purchase xx predominantly IT xxxxxxxxxxxxxxxx and leasing xxxxxxx Leasing xxx xxxxxxx equipmentfirst xxx second mortgage xxxxxxxxxxxxxxxx and motor xxxxxxxxxxxxxxxx financeInvest xx xxx series xx Credit linked xxxxxxxxxxxxx financeFor taking xxxx Goodman xxxxxxxxxxx xx other xxxxxxxxx under GPG xxxxxxx Ltd? No x ranked xxxxxxxxxx xxx RuralManufacturingBusiness xxxx Residential DevelopmentMotor xxxxxxxx loanMachinery contractorsLand/sub xxxxxxxxxxxxxxxxxxx lendingsubdivisions xxxxx xxxxxxxx Finance xxx insuranceHealthServiceCommercial CustomersCommerical xxxxxxxxxxxxxxxxxxx concentration of xxxxx Taranaki xxxxxxxxxxxxxxxxx xxxxx of xxxxx IslandAucklandCanterburyNelsonRest of xxxxx IslandParent CompanySouth xxxxxxxxx finance xxxxxxxxx xxx Zealand xxxxxxxxxxxxx Holdings Ltd xxxxxxxxxx Capital Ltd xxxxxxxxxxxxx Pacific xxxxxx xxxx LtdClegg xxxxx Co Havnor xxxxx Holding LtdHanover xxxxxxx LtdAF xxxxxxxxxx xxxxxxxxxxxx Capital xxx Ltd (AU)Origination xxxxxxx Systems Pty xxxxxxx Xerox xx xxxxxxxxx lockie xxxxxxxxx Motors Acceptance xx GE Capital xxxxxx Finance xxxxxxxx xxx (US)Forsyth xxxx Group LtdBurns xxxxx & Companyparent xxxx 2Belgrave xxxxxxx xxxxxxxx AGAmerican xxxxxxx Co GE xx (US)parent info xxxxxx Investment xxxxxxxxxxx xxxxxx (full xxxx equivalent)SUMMARY STATISTICSProfitablility x EfficiencyReturn on xxxxxx (net xxxxxxx x average xxxxx assets)Return on xxxxxx (net surplus x average xxxxxxxxxx xxxxxxxx margin xxxx interest income x average tot xxxxxxxxxxxxxxx income xx x of xxxxxxx loan assetsInterest xxxxxxx as % xx average xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxx as x total operating xxxxxxxxxx income ratios:Operating xxxxxxx / xxxx xxxxxxxx income x other income)Operating xxxxxxx / (net xxxxxxxx income x xxxxx income x impaired asset xxx )Capital ratio xxxx risk.....
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable