Description of this paper

FIN 350 Chapters 2 and 3 Textbook problems




Question;FIN 350 Using Excel, complete the following problems from chapters 2 and 3 in the textbook:1. P2-12. P2-43. P2-84. P2-115. P3-16. P3-57. P3-108. P3-11Template Use:1. Non-colored cells require data input which is given in the problem.2. Colored cells require a calculation. All colored cells are graded.Investment12Year 0$4,000,000.00$2,600,000.00A.Combined Value =B.% Increase in Value =% Increase8.60%5.20%$6,600,000.00Year 1$4,344,000.00$2,735,200.00$7,079,200.00PreliminaryCalculations3. Yellow colored cells involve a preliminary calculation. The result of thiscalculation will be used in subsequent calculations.4. Gray colored cells are final calculations. This calculation represents theanswer to the question.5. Students must enter the formula directly into the cell for full credit.7.26%A Final CalculationFormula entered directly into cell.Where are the instructor add-ons?Resources > Course Material > Add-Ons > Instructor Add-OnsClick on any shaded cell to seethe formula (in the formula bar)used to obtain the answer.For additional assistance on how to use Excel,please review the PowerPoint on Excel Basicslocated in the Instructor Add-Ons.For assistance on basic mathematics includingpercent problems, please work through theMathematics Review document located ininstructor add-ons.Module 1 Assignment Grading RubricP2-1Data PresentationCorrect SolutionDemonstration of MethodTotal PointsMax2114Student Grading DataStudent Score0Total Possible Points84% Grade0.0%Max. Gradebook Points60Gradebook Score0.0My0P2-4MaxMy23380P2-8MaxMy23380P2-11MaxMy266140P3-1MaxMy266140P3-5MaxMy23380P3-10MaxMy266140P3-11MaxMy266140Assignment Grading Notes:Data Presentation: Each problem must be well organized with all information being clearly identified tothe reader. A person looking at the problem should be able to clearly read, understand,and interpret thedata being presented. The template has been set up to do exactly this, therefore using the template willguarantee full points for data presentation.Correct Solution: The final solution to each problem (or each part of the problem) is located in a grayshaded cell on the template. Each gray shaded cell is worth 1 point. If the answer is correct the point isawarded, if the answer is incorrect then it is not. Each yellow shaded cell on the template represents anintermediate calculation that is required to complete the problem. Each yellow shaded cell is also worth 1point.Demonstration of Method: Every shaded cell requires a calculation to be entered in the cell whichdemonstrates how you obtained the value in the cell. This calculation is worth 1 point. if this calculation isomitted, you will not receive this point.This rubric will be located on the second tab on every assignment. I will complete the rubric and attach itto your grade report in the grade book. I will also attach the solutions to the assignment so that you maycompare your work with the correct solutions.ItemCurrency & Traveler's ChecksNegotiable CD'sDemand DepositsOther Checkable DepositsSize of M1 Money Supply =AmountComponentCurrencyDemand DepositsOther Checkable DepositsTraveler's ChecksLast YearGrowth Rate$700,000,000,000.0010%$300,000,000,000.005%$300,000,000,000.008%$10,000,000,000.000%M1 Money Supply =Next YearMoney SupplyM1 Money SupplyM2 Money SupplyGross Domestic ProductReal OutputA.M1 VelocityB.M2 VelocityC.Average Price for Real OutputOne Product Economy - PC'sThis YearReal OutputNominal GDPMoney SupplyVelocityNext YearnaA.Average Selling PriceB.Average selling Price% Change in Price levelC.GDP with No InflationMoney Supply with no Inflation% Increase in Money SupplyD.VelocityMoney Supply with no Inflation% Increase in Money SupplyA. LoanLoan ALoan BLoan CAmount of Loan Discount RateInterestThe loan that provides the most upfront money is loanB. LoanLoan ALoan BLoan CEffective CostThe loan with the lowest cost is loanNet ProceedsAccountsVault CashU.S. Government SecuritiesDemand DepositsNon-transactional AccountsCash in Process of CollectionLoans to IndividualsLoans Secured by Real EstateFederal Funds PurchasedBank PremisesAmountTotal AssetsTotal LiabilitiesOwners CapitalAssetCashGovernment SecuritiesMortgage LoansOther LoansFixed AssetsIntangible AssetsTotal AssetsLoan-loss ReservesOwners EquityTrust-preferred SecuritiesA. Equity capital RatioB. Tier 1 RatioC. Total Capital RatioAmountWeightRisk-Adjusted AssetsAccountsCash AssetsLoans Secured By Real EstateCommercial LoansGovernment Securities OwnedGoodwillBank Fixed AssetsTotal AssetsDemand DepositsTime and Savings DepositsFederal Funds PurchasedTrust Preferred SecuritiesOwners CapitalLoan Loss ReservesA. Equity Capital RatioC. Tier 1 RatioD. Total Capital RatioAmountWeight Risk-Adjusted AssetsHow could the bank increase its equity capital ratio?Answer:What actions could the bank management team take to improve the bank's Tier 1and Total Capital ratios?Answer


Paper#48132 | Written in 18-Jul-2015

Price : $31