Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Additional funds needed problems and solutions

03/05/2021 Client: muhammad11 Deadline: 2 Day

FIN4934 George Washington Forecasting Additional Financing Needed Project
Subject
Business Finance

Course
FIN4934 Financial Modeling

Question Description
use AFN equation to solve problem, please do not use Excel, show your calculations. Just use calculator to get answer, put to word document.

Using the Plug: Forecasting Additional Financing Needed Go to Blackboard under class 4 materials and use the data from the spreadsheet we discussed in class. (The base year is in column C): 1) Use the “additional funds needed” (AFN) equation illustrated in class to find Style’s forecasted AFN under the following different scenarios (presuming AFN is borrowed or reflects debt repaid): • growth rate = 25% • growth rate = 0% • payout ratio = 20% (with growth rate = 15%) • payout ratio = 70% (with growth rate = 15%) • interest rate = 4% (with growth rate = 15% and payout ratio = 45%) • interest rate = 20% (with growth rate = 15% and payout ratio = 45%) 2) For each scenario, what are the AFNs if cash (not Notes Payable) is the balancing figure? g ( A * − L*) − ( EBIT )(1 + g )(1 − T )(1 − d ) + I 0 (1 − T )(1 − d ) 1 − i(1 − T )(1 − d ) OBS: In the above mentioned scenarios only g, d and i are allowed to vary. Show your calculations. 3) How does AFN vary with: • growth rate? • payout ratio? 4). Assuming that in 2018 (base year) fixed assets had been operated at only 75% capacity, under the scenario of 25% growth rate what can you say about the AFN? 5). If Sales would increase to $50,000 what would the Fixed Assets requirement be? 6). How would excess/deficit capacity affect the forecasted ratios? Developing Pro Forma Financial Statements 1) Develop a sales forecast. 2) Based on forecasted sales, create a pro forma income statement. 3) Develop a preliminary forecasted balance sheet. In doing so, you must predict how the forecasted change in sales will affect the need for additional assets (both current and fixed assets). Additionally, will changes in sales precipitate any additional liabilities? This must also be incorporated into the balance sheet forecast. Finally, leave capital accounts (i.e., equity and long-term debt) unchanged. 4) After the first 3 steps, you will notice that this pro forma balance sheet will be unbalanced (i.e., assets not equal to liabilities plus shareholders equity). 5) The “gap” in the balance sheet may be eliminated by using one or a combination of plugs: a. incorporating additional (or subtracting) financing (i.e., assuming more or less debt OR more or less equity) into the balance sheet forecast. If you take this approach, you should also adjust for any financing feedbacks. Or if you assume less equity, will the firm pay less in dividends? b. Adjusting cash as necessary. c. A combination of plugs. 6) Management assesses the plan, and may call for changes. An additional way to forecast would be to analyze the historical changes in assets as sales grow (or decline). This would best be accomplished through a regression methodology. Style's Pro Forma Financial Statements Interest rate on new debt Let's assume Income Statement: Sales Op costs 2019 10% Assumed growth rate in (Sales, Op. Costs, Cash, A/R, Inv, Net PPE, A/P, Accruals) 15% Dividend payout ratio 45% Pro forma 2018 2019 Adjusted $ 36,000 $ $ 32,440 $ - 2019 Initially keep Interest = Constant and N/P = Constant LT Debt =Constant Equity = Constant Let's forecast 2019 DEMONSTRATE HOW GROWTH HAS FINANCIAL IMPLICATIONS line items Q1. What changed by the same percentage as Sales? 1 EBIT Interest $ $ 3,560 560 $ $ - 2 3 EBT Taxes (40%) $ $ 3,000 1,200 $ $ - 4 Q2. What are the funding sources? Net inc $ 1,800 $ - Divs (45%) Add to RE $ $ 810 990 $ $ - Balance Sheet: Assets: Cash A/R Inv Cur assets Net PPE Total assets Transfer cells Ds to Es 1 2 $ $ $ 1,080 6,480 9,000 $ $ $ - $ $ $ 16,560 12,600 29,160 $ $ $ - (and therefore into equation d)), we can break this down into 2 equations and 2 unknowns (AFN and addition to R/E). Ultimately, we can define AFN (incorporating financing feedbacks) as: AFN = g ( A * − L*) − ( EBIT )(1 + g )(1 − T )(1 − d ) + I 0 (1 − T )(1 − d ) 1 − i (1 − T )(1 − d ) Where A* = assets that increase proportionally with sales L* = liabilities that increase proportionally with sales 2018 2019 $ Adjusted - 4,320 2,880 2,100 $ $ $ - $ $ $ $ 12,860 $ 12,860 Cur liabilities LT debt Common stock RE $ $ $ $ 9,300 3,500 3,500 12,860 Total L&E $ 29,160 $ - $ - g = growth rate in sales EBIT = operating income T = tax rate d = dividend payout ratio I0 = interest expense (ignoring any additional financing) i = interest rate on additional funds borrowed AFN Assets - L&E $ (12,860) NOTES:Use Tools Solver (add-in) to set Difference cell equal to 0 by changing the AFN cell. Note that total interest relies on the amount of AFN, thus impacting addition to RE. 3.51% 6.44% 78.24% NI ) TA NI 1 − b( ) TA b( Internal Growth rate Ratio of Liabilities to Equity 4 Q3. HOW CAN WE ACCOUNT FOR ADDED INTEREST? 1) Estimate the following system of equations (NOTE: the following process assumes that all new funds are borrowed at the beginning of the yr) a) Additional interest = additional funds borrowed (AFN) x cost of new borrowing b) (1+g) x Total assets = (1+g) x (A/P + Accruals) + (N/P + AFN) + LT debt + common stock + (R/E + Addition to R/E) c) NI = (Sales – Operating costs) x (1-T) – Interest x (1-T) d) Addition to R/E = NI x (1 – dividend payout ratio) In equation a), additional interest depends upon AFN (unknown). In equation b), we have 2 unknown variables, AFN and addition to R/E. Eq. d) shows that addition to R/E depends on NI (which is affected by how much interest is paid. So, substituting equation a) into c) Liabilities & Equity: A/P $ Accruals $ N/P $ Internal growth rate: Sustainable growth rate:

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Homework Helper
Helping Engineer
Top Academic Tutor
Math Exam Success
Academic Mentor
Maths Master
Writer Writer Name Offer Chat
Instant Homework Helper

ONLINE

Instant Homework Helper

I have read your project details. I can do this within your deadline.

$42 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$15 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I have read your project details. I can do this within your deadline.

$33 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have read your project details. I can do this within your deadline.

$49 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$42 Chat With Writer
Maths Master

ONLINE

Maths Master

I have read your project details. I can do this within your deadline.

$44 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Prepare a flexible budget for march - Data Analytics - Simple pendulum lab report discussion - Cameolord pharmacy oxford road - Healthcare Informatics and Technology - How to draw a genogram in microsoft word - Statistical sampling and non statistical sampling - Home depot my apron infocus - The Middle Ground Method of Argumentation - Assignment 2 - Monopoly project file class 12 - Zurich company reports pretax financial income of 70000 - The opportunity cost of going to college is - New dvd rentals at hastings - Before giving care - Who directed big fish - Technology trends proposal part lll - Draft Review - Data Analysis - Chemistry research topics high school - 4-2 - Why does haimon attack his father with a sword when they meet in the cavern? - Victoria bushfire prone area map - Semiotic systems in multimodal texts - Sulfuric acid 98 percent - Ben goldacre battling bad science - Challenge yourself 3.3 excel answers - Uts timetable planner 2021 - BUSN603 - Walden university mission of social change - Hhd study design 2017 - 6640 salisbury rd maumee oh 43537 - Conduct a value chain analysis of the walt disney co - Develop a promotional message - Regal evesham loyalty card - Project - When was the fax machine invented - The other wes moore essay outline - How to translate europass cv - Chapman building salford university - Lysaght price list 2021 - Stephen hillenburg rules for spongebob - Best practices for lan domain compliance - The importance of user technology security education within organizations - Excel sam capstone project 1 campus fitness center - What is incompatibility in pharmaceutics - The pillow method is designed to - What are labor costs in ms project - Which functional group is within the compound shown below - Probability - Da lite screen cleaning - What color does ammonium carbonate burn - Case study on international human resource management with solution - Concept identification and definition - Aviation id australia asic renewal - Ashrae heat balance method - Truity big 5 personality test - Management Accounting Coursework - Dr cakebread and partners - Hyatt regency hotel walkway collapse cause - Bill cosby hello friend sweatshirt - Negotiation preparation worksheet - Long term capital management case study - Greasers and socs fight - The cvp income statements shown below are available for armstrong company and contador company. - What is good form in accounting - Practical Connection Paper ; 2-3 pages ; Due Oct 03, 12pm EST - Police signal codes florida - Why did gonzo walk around carrying - PAPER - Topographic map worksheet answer key - Journal 8 - Accounting chapter 11 comprehensive problem 3 - Https www google com search q sex offender registry - Do roms need to be unzipped retropie - Aerial bundled conductor specification - Semantic feature analysis chart - Assignment 2 - Stone keep castles disadvantages - An aluminum plate cm thick is to withstand - Past tense picture cards - Why is documentation important to accounting information systems - Recommendation report example - Paper 1 - Discussion post required on access control - What is a good topic for a commemorative speech - Fish philosophy video free download - Tstc admissions phone number - Hilton parma soccer club - Epremis billing manual - Chapter 1 gross income lesson 1.1 straight time pay answers - Values in daddy by sylvia plath - Dare to dream performance horses - The nike shoe investigation worksheet answers - 1 case Study and 1 Journal article in APA format - Kid punches wall modern warfare 2 - The volcano mission cornelia funke - Development of hris - Tp castt poetry analysis answers - Edgewood lake hospital case study