Excel : Week4 Solution

a)b)c)d)e)Option 5Option 5Option 3Option 1Option 3a)b)c)d)e)Option 1Option 1Option 2Option 1Option 1Given Dataa)1)2)3)4)5)b)The other statements that would be of interest to the bank are the Cash Flow Statements to understand the cashThe Bank will also need to check the Budgeted Financial Statements to understand the projected performance ofAlso, the Bank would need to conduct solvency and asset management efficiency ratio analysis to understand thec)SalesCOGSGross ProfitNet IncomeAdd: DepreciationLess: Cash dividendsLess: Note repayment and interestFunds available for expansionFunds required for expansionExcess fundsAssumptions - Dividend per share grows at 25% and Depreciation expense remains constant and the funds requirefor expansion is equally split in 2 years i.e. 150,000It is clear that financing the plant expansion through internal funds is realistic as long as the notes repayment of 6Without the extension of 24 months on the 60,000 payment the company could face funds issue in 2012 even thod)Yes, the Bell National Bank should grant extension to Warford's notes as it will ease the cash outflow due to notesthe firm has enough funds available for expansion cumulatively and the only problem is due to the timing of notes2010AssetsCashNotes receivablesAccounts receivablesInventoriesPlant and equipmentTotal Assets12,500104,00068,50050,000646,000881,000Liabilities and Owners' EquityAccounts P ...


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

Answers

Related Questions

Health & Medical : Kinesiology...

KinesiologySurname1Name:Professor:Course:25th April 2019.Kinesiology/physical education addresses the interconnection between science andexercise .I m...

Computer Science : Assignment 3 Requirements Guide...

REQUIREMENTS GUIDEcreate three pages of your site that include the following: - Over 3 pages createdNavigation links that are consistent on all pages...

Biology : Agree Or Disagree...

1. Paragraph 1 responseI agree that children need to undergo regular eye check-ups to so that vision problemsmay be identified and possibly treated be...

Economics : Market Competition...

Main title: The IMF adds to a chorus of concern about competitionSummaryThe article, The IMF adds to a chorus of concern about competition postulates...

English : Do Not Go Gentle Into The Night.......

Running Head: DO NOT GENTLE INTO THE NIGHT"Do Not Go Gentle into the Night"Students NameInstitutional AffiliationDate1DO NOT GENTLE INTO THE NIGHT2"Do...

Health & Medical : L16 Final Draft...

Using the example of From the Front Lines in Chapter 6 of your text, calculate the break evenfor the number of procedures. Use an electronic spreadshe...

Business : Demand And Quantity Demanded...

Demand and Quantity DemandedDemand and Quantity DemandedStudent NameInstitute NameDateCourseDemand and Quantity DemandedChange in DemandA change in de...

English : Analysis Of Dreams...

ANALYSIS OF POEM DREAMSIntroduction:Langston Hughes was an American poet who was famous for his fictions, poetry, novels orplaywrights etc. He was als...

Programming : Mergesort Updated 1...

import java.util.Random;public class MergeSort {public static void main(String... args){int[] input_100 = generateInput(100);long startTime_100 = Syst...

Mathematics : Area And Length Assignment...

Find the area of a triangle.Problem: Find the area of a triangle whose sides are 5cm, 6cm and 7cm. Where a=5, b=6, c=7. Use Herosformula to calculate...

Business : Business And Government Relations...

BUSINESS & GOVERNMENT RELATIONS"Business and Government Relations"Your nameYour Instructors nameCourse Id:Your instituitions nameDate:1BUSINESS & GOVE...

Sociology : Leroy Karas Ecomap Review...

If you feel good we can discus at gmail my email is [email protected] can mail me anytime as studypool do not allow us to share personal informa...

Accounting : On May 31 2012...

On May 31, 2012, Express Delivery, the overnight shipper, had total assets of $21,000,000,000and total liabilities of $13,000,000,000. Included among...

Management : Eagege...

1. Modern-day corporation that does not wish to participate in global competition may begradually digging its own grave in such a way that a lot of as...

Environmental Science : Thermodynamics...

Running head: LAWS OF THERMODYNAMICS1The laws of ThermodynamicsNameInstitutionDateRunning head: LAWS OF THERMODYNAMICS2The first law of thermodynamics...

Mathematics : Sinusoidal Real World...

The number of hours of sunlight on a given day throughout the year varies according toperiodic changes in season. Periodic changes in the tilt of the...

Humanities : Philosophy homework help needed for...

Describe two (2) specific aspects about the Great Wall of China, such as facts about its size, length, purposes, varied materials, labor force, and it...

English : Reflective Report.edited...

Running head: REFLECTIVE REPORT1Reflective ReportStudents NameInstitutional AffiliationREFLECTIVE REPORT2Farmers in Kenya experience a problem of lack...

Management : Gannt Chart...

64-May-1843-May-18152-May-18151-May-181530-Apr-1829-Apr-181328-Apr-1826-Apr-181227-Apr-1825-Apr-18choose themeextend invitationsplan menuclean the hou...

Health & Medical : Answer...

What is the difeeeene betweee good banteeia aed bad banteeia? Please list all the difeeeenes aswell as how they both afenttieteeant with oue oegaeism....

Business : 1556180165845 1556180163451 0 Logistics...

Running head: LOGISTICS AND DOCUMENTATIONLogistics and DocumentationSouthern Markets Affiliates1LOGISTICS AND DOCUMENTATION2Transportation plays a big...

English : Greek Tragedy And Medieval Romantic Tale...

Greek tragedy and medieval romantic talesThe medieval romance and the Greek tragedy tales exhibit a lot of similarities in theirsetting, even though t...

Physics : Mirror Question...

When we look in the mirror, it seems as if left and right are being swapped. But why doesnt themirror swap up and down?That is because we are being mi...

Sociology : Reading Response......

Running head: READING RESPONSE1Reading ResponseStudents NameInstitutional AffiliationREADING RESPONSE2After reading through the material, I have notic...

If you didn't find the right answer

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