Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Cash Budget Graded Practice Problem
The owner of Lazy Inn has been requested by First National Bank to submit a cash budget for the next calendar year. With that in mind, please prepare the following:
After preparing the above schedule, can you provide the owner with some guidance as to whether:
Cash Inflows
Room
Qty
Jan-Mar & Dec. Price/Occupancy Rate
Apr-May Price/Occupancy Rate
June-Aug Price/Occupancy Rate
Sept.-Nov. Price/Occupancy Rate
1 king size bed/room
10
$58 / 85%
$40 / 50%
$58 / 75%
$45 / 55%
2 king size beds/room
60
$70 / 80%
$48 / 55%
$50 / 58%
2 bedroom (2 kings/room)
20
$80 / 78%
$60 / 40%
$80 / 88%
$64 / 60%
10 executive suites
$120 / 95%
$90 / 45%
$120 / 100%
$95 / 65%
On your cash budget, be sure to show each room type's cash flow individually (and total for all rooms by month)
Cash Outflows
What is the highest cumulative amount that needs to be borrowed during this 12 month period? Use the roundup function to round this amount to the highest thousand dollar amount (e.g. 12,400 would become 13,000).
As usual, use only functions and formulas along with proper formatting in preparing this cash budget. DO NOT have any numbers in formulas. Results should be to the nearest dollar.
Calculate the price adjustments for the two types of anti-dilution provisions. Which anti-dilution clauses do the Series A investors prefer? What about the Series B investors?
As a member of finance team, you have been asked to create upcoming year organizational budget for your dietary department at Krona Community Hospital.
Progressive Tech Company incurred research & development costs of $190,000 and legal fees of $54,000 to acquire a patent. The patent has a legal life of 20 years and a useful life of fifteen years.
Evaluate Leverage keeping the short-term debt as part of total debt
The plan should include a mission statement, statement of values, code of conduct statement, written standards and whatever other categories your team believes are required to deal with the many problems facing this company.
Use the following information from a company pro forma financial statements to compute the following profitability ratios for the company,
Compute the current weighted average cost of capital (WACC) of DEI. Show all workings and state clearly the assumptions underlying your computations.
Why are cash flows that are connected to common stock difficult to estimate? How does this compare to those related to bonds.
Determine the interest expense that Rainey Corporation will show with respect to these bonds in income statement for the fiscal year ended September 30, 2010, suppose amortized premium is $67,000.
On January 1, 2008, Rans Corporation purchased a patent for $595,000. The patent is being amortized over its lasting legal life of fifteen years expiring on January 1, 2023.
Valuation of stock using CAPM - Estimate the value of Cargo Point, Inc. stock.
Three (3) stocks have share values of $12, $75, and $30 with total market rates of $400 million, $350 million & $150 million respectively.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd