Business : 20200831171709wacc

WAC=[E/D+E]Re + [D/D+E](1-T)RD = [1-L]Re+L[1-T]Rdwhere E is total Equity, D is total debt, re is requied return on equity, rd id required return on debt, L is the percentage debt aSpreadsheet CalculationEnter DataRequired return on debtRd0.110751993Required return on equityRe0.076187653Marginal Tax RateT0.406466513Debt %L0.407552141Equity percentage0.59244785912345Income StatementTotal RevenuesTotal ExpensesNIBTTaxesNet Income After TaxActual CalculationsReturn/DebtReturn/EquityTax/NIBTDebt/(Debt+Equity)Equity/(Debt+Equity)$$$$$Spreadsheet CalculationNumerator$ 1,028,000.00$ 1,028,000.00$704,000.00$ 9,282,000.00$ 13,493,000.00Denominator$ 9,282,000.00$ 13,493,000.00$ 1,732,000.00$ 22,775,000.00$ 22,775,000.0048,490,000.0046,758,000.001,732,000.00704,000.001,028,000.00Enter DataRequired return on debtRd0.384481499Required return on equityRe0.244134442Marginal Tax RateT0.164764801Debt %L0.388368201Equity percentage0.61163179912345Income StatementTotal RevenuesTotal ExpensesNIBTTaxesNet Income After TaxActual CalculationsReturn/DebtReturn/EquityTax/NIBTDebt/(Debt+Equity)Equity/(Debt+Equity)Numerator$ 3,568,757.27$ 3,568,757.27$704,000.00$ 9,282,000.00$ 14,618,000.00OLD$$$$$NEW$ 60,337,441.72$ 56,064,684.45$ 4,272,757.27$704,000.00$ 3,568,757.2748,490,000.0046,758,000.001,732,000.00704,000.001,028,000.00Denominator$ 9, ...


To Order an Original Plagiarism Free Paper on the Same Topic Click Here

Answers

Related Questions

Business : Slides...

MultinationalCorporateFinanceHISTORY OF CHINA & USARELATIONSHIP1784: First Representatives of the United StatesWent to China1785: First Chinese Arrive...

Other : Review...

Running head: ARTICLES REVIEW1Articles ReviewStudents NameInstitutional AffiliationsARTICLES REVIEW2Review 1Hansen, Lambert, and Vlass (2015) in their...

Art & Design : New Realism And Pop Art...

Running head: NEW REALISM AND POP ARTNew Realism and Pop ArtStudents NameUniversity AffiliationProfessors nameCourse titleDate1NEW REALISM AND POP ART...

Health & Medical : Health Care Reform Project Part...

NameInstitutionHigh health care spending is a major concern inAmericas health sector.Avoidable population risk factors such as stressand obesity tend...

Philosophy : Conflict Resolution...

Running head: CONFLICT RESOLUTION1Conflict ResolutionNameCourseProfessorDateCONFLICT RESOLUTION2Conflict Resolution#4: Program Learning Outcome: Lead...

Science : Rhetorical Analysis Of Three Advertiseme...

1Rhetorical Analysis of Three AdvertisementsNameDate2We are believing that using rhetorical appeals can attract as well as retain customers tolong ter...

Business : Analysis Of Ground Rules...

Running head: GROUND RULES1Analysis of Ground RulesInstitution AffiliationDateGROUND RULES2Analysis of Ground RulesI once worked as a team member in a...

Management : Theoretical Foundations Of Students D...

Running head: THEORETICAL FOUNDATIONS OF STUDENTS DEVELOPMENTTheoretical Foundations of Students DevelopmentStudents NameInstitutional AffiliationInst...

Algebra : Questions...

1. 0.30(80) + 0.60x = 0.40(80 + x)24+0.6x=32+0.4x0.6x-0.4x=32-240.2x=8X=40Check 24+0.6*40 = 32+0.4*4024+24=32+1648=482. 0.40x - 0.20(50 + x) = -0.04(5...

Business : Team Development Session Two...

Running Head: TEAM DEVELOPMENT SESSION 2Team Development Session 2NameInstitution AffiliationDate1TEAM DEVELOPMENT SESSION 22Team Learning and Systems...

Business : Organizational Team Development Analysi...

Running head: ORGANIZATIONAL TEAM DEVELOPMENT ANALYSISOrganizational Team Development AnalysisNameInstitutionDate1ORGANIZATIONAL TEAM DEVELOPMENT ANAL...

Business Law : Weekly Db...

Weekly DBshttp://www.ndaa.org/pdf/Castle%20Doctrine.pdfFrom the first e-Activity, Specify the key reasons why legislatures inflicted capitalpunishment...

Economics : Capital Flow...

Running Head: CAPITAL FLOWS1Capital FlowsNameInstitutional AffiliationCAPITAL FLOWS2Capital flows may cause an increase or decrease in current dependi...

Business : Health Information Management 4...

Running head: MEDICAL INSURANCE IN FLORIDA STATEHealth Information Management: Medical Insurance in Florida StateNameInstitution1MEDICAL INSURANCE IN...

Marketing : Project Deliverables...

Running head: PROJECT DELIVERABLES1Project deliverablesStudents nameProfessors name,Course titleDatePROJECT DELIVERABLES 21.Project deliverables refer...

Health & Medical : Technology Impact On Healthcare...

Running head: TECHNOLOGY IMPACT ON HEALTHCARETechnology Impact on HealthcareStudents HealthInstitution1TECHNOLOGY IMPACT ON HEALTHCARE2Technology Impa...

Writing : Project Reviews...

Evaluation1Projects EvaluationNameInstituteInstructorSubmitted OnEvaluation2Evaluation 11.The name of the company that we are evaluating is City Bound...

Communications : Interview Essay...

Surname 1Student NameCourseInterview SummeryDateSummery and SynthesisJohn Andrew is an Information Security officer who has had about thirteen years o...

English : Ending Illiteracy In France...

Ending Illiteracy in FranceInterpreting the pictured advert the ad is to promote awareness for the growing illiteracyrates in France. This ad is purp...

Communications : R096.edited...

Running head: CLASSIFICATION OF MOTHERSClassification of MothersStudent's NameInstitutional Affiliation1CLASSIFICATION OF MOTHERS2Classification o...

Communications : Frankenstein....

Surname 1Name:Tutor:Course:Date:The Frankenstein ApplicationIntroductionMary Shelley's Frankenstein gives us accounts of personal perception in di...

Python : Part 3 Mini Lab 2.....solved...

Part 3: Mini-Lab 2After running the ipconfig command, I determined that my IPv4 address was192.168.0.11 and the corresponding IPv6 was fe80::f0c9:9ff5...

Philosophy : Kant S Pilosophy....

Surname 1Name:Professor:Title:DateAPPLICATION OF IMMANUEL KANT'S PHILOSOPHICAL IDEASPhilosophical knowledge is essential in our daily life. We hav...

Business Law : Clinical Decision Support...

Running head: CLINICAL DECISION SUPPORTClinical Decision SupportName of the StudentName of the Affiliate InstitutionDateCLINICAL DECISION SUPPORT2Clin...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it