If my beginning cash balance is 100,000 with current A/R 50,000 net terms of 30, sales by quarter 100,000 and my COGS is 70%. rent = $2500, payroll: 2,000 per month, payroll taxes: paid weekly at a rate of 15% of payroll. how do I build a projected cash flow for the year, by month?

If my beginning cash balance is 100,000 with current A/R 50,000 net terms of 30, sales by quarter 100,000 and my COGS is 70%. rent = $2500, payroll: 2,000 per month, payroll taxes: paid weekly at a rate of 15% of payroll. how do I build a projected cash flow for the year, by month?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter19: Capital Investment

Section: Chapter Questions

Problem 23E: Assume that an investment of 100,000 produces a net cash flow of 60,000 per year for two years. The...

See similar textbooks

Related questions

Q: A set of cash flows begins at $15,000 the first year, with an increase each year until n = 12 years.…

A: The current value of the cash flow or stream of cash flow after discounting is termed as the present…

Q: what is the future value of cash flow of ¢2,000.00 for the first month and a monthly rise of 0.1%…

A: 1st deposit =2000 Increase per month = 0.1% = 0.001 Increase Factor(r) = 1+0.001 = 1.001 Number of…

Q: Using the tables provided, if an investment is made now for $19,200 that will generate a cash inflow…

A: Given, The investment is $19,200 Cash inflow is $6,400. Rate is 10%

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: Answer: Cash flow for first month = $4000 It decreases $75 every month till 5 years rate of…

Q: What amount of money invested today at 15 % interest can provide the following scholoarships: Php…

A: Given, R= 15% A1= PHP 30,000 N1= 6 A2= PHP 40,000 N2= 6 A3= PHP 50,000

Q: If projected net cash flow for November is ($10,000); beginning cash balance is $4,000; minimum cash…

A: We use excel to solve this problem Minimum balance is 3000

Q: Suppose you start each month with a cash balance of P100,000 and you use cash evenly throughout the…

A: OPPORTUNIY COST means the earning lost due to retaining cash ,if we invest the same cash elsewhere…

Q: Consider two investments:1. Invest $1000 and receive $110 at the end of each month for the next 10…

A: Investment 1: Initial investment=$1000Interest rate=12% Uniform annual benefit=$110 Investment 2:…

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: Present value of cashflow = Cashinflows/(1+Interest rate) Given, Interest rate = 12% per year…

Q: Suppose that you deposit $200 at the end of each month into an account paying an expected annual…

A: given, monthly compounding N =10 x 12 = 120I =3%12PV =0PMT =200 FV = need to find

Q: Beautinator Cosmetics borrowed $152,300 from a bank for three years. If the quoted rate (APR) is…

A: Answer: Calculation of the effective annual rate (EAR): Formula of effective annual rate: EAR = (1+…

Q: A sum of money is deposited now in a savings account. The effective annual interest rate is 12% and…

A: There are various types of Bank Accounts, one of the basic and most commonly used is Saving's…

Q: Merchandise is received for $25,000 now and $50,000 in 6 months. If $10,000 is paid within a month,…

A: Honor code: Since you have asked multiple questions, we will solve the first question for you. If…

Q: What is the combined present value of cash you will receive from your clients if r = 6% APR with…

A: Time value of money (TVM) refers to the method or technique which is used to measure the amount of…

Q: hat capital must be invested to have $

A: Time value of money (TVM) means the amount of money received in the present period will have more…

Q: An accountant wants to withdraw $30,000 from an investment at the beginning of each quarter for the…

A: Time value money is the concept widely used by the management and individual to determine the…

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: Cash flow is defined as the movement of the funds that inflows as well as outflows of the…

Q: how do I build a projected cash flow for the year, by month?

A: Given in the question Beginning cash =$100,000 A/R = 50,000 net terms of 30 Means received within 30…

Q: Find the cash value of a sala set that can be bought for 2,500 down payment and 288 a month for 36…

A: Cash value =loan amount +down payment We need to use present value of annuity formula to calculate…

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: The question is based on the concept of Financial Management. Annuity refers to the series of…

Q: What is the approximate annual cost of foregoing the cash discount if the credit term is 2/15, net…

A: The company pays the amount on the 50th day. Credit term = 2/15, net 45 days. This credit term…

Q: A set of cash flows begins at $80,000 the first year, with an increase each year until n = 10 years.…

A: Present Value(PV) is current value of any amount that is to be paid or received in future. It is…

Q: You invest $5,000 into a money market account that pays interest monthly (e.g., interest is…

A: Future Value = Present Value * (1+r)^n Where, n = no. of compounding period i.e. 3 years * 12 = 36 r…

Q: Philip Morris expects the sales for his clothing company to be $630,000 next year. Philip notes that…

A: Given, Sales = $630,000 Return on total sales = 10% Bank balance = $230,000

Q: client at ZBX Fin Planning currently has $95,000 in their retirement account that is expected to…

A: Future value of money increases with increase in time and more deposit being made and more interest…

Q: At the end of each year for the next 18 years you will receive cash flow of $3700 the initial…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: 20. $1,000 is deposited each month in an account paying 4.23% for 15 years. Then, $350 is deposited…

A: Note : As per our guidelines, we can only answer one question at once. Please post other question…

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: Interest Rate = 12%/12 = 1% per month Cash Flow in month one = 4000 Cash Flow in month two = 3925…

Q: If you make quarterly deposits of $1000 for 15 years into an account that compounds interest at 1.5%…

A: Quaterly deposit is $1000 Time period is 15 years Interest rate is 1.5% To Find: Future Value

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: First, We need to compute the present value of cash flows using NPV formula in excel. Then we should…

Q: A company will need $40,000 in four years for a new addition. To meet the goal, the company will…

A: According to the concept of future value and present value, investor is estimating the nearest value…

Q: An investment costs $465 and is expected to produce cash flows of $100 at the endof each of the next…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: The cash flow associated with a stripper oil well is expected to be $4,000 in month one, $3,925 in…

A: Interest Rate = 12%/12 = 1% per month Cash Flow in month one = 4000 Cash Flow in month two = 3925…

Q: A company expects to receive the following cash flows $2,000 for the first ten years and then $3,000…

A: Present value refers to the current valuation for a future sum. Investors determine the present…

Q: Find the amount at the end of two years and seven months if 6,000.00 is invested at 9% compounded…

A: Investment = 6000 Interest Rate = 9% Compounded Quarterly Number of compounding periods = 4

Q: The present amount needed to generate an annual income of $50,000 for 20 years if the expected rate…

A: Hello. Since your question has multiple parts, we will solve the first question for you. If you want…

Q: Another client at ZBX Fin Planning currently has $95,000 in their retirement account that is…

A: Current Amount in account is $95,000 Deposits per month is $950 Interest rate is 10.56% APR…

Q: What is the present value of end-of-year cash flows of 1000 per year, with the first cash flow…

A: Present value is the sum of discounted future cashflow

Q: How much should I deposit today at 10% per month to obtain the following cash flows in a period of…

A: Annual interest rate = 10% Monthly interest rate = 10%/12 = 0.83333333333%

Q: A set of cash flows begins at $25,000 the first year, decreasing 10% each year until n = 10 years.…

A: The present value is the sum of cashflows discounted at given discount rate

Q: What is the present value of end-of-year cashflows of $1,000 per year, with the first cashflow…

A: Present value is the value today of future cash flows discounted to present terms using a specified…

Q: What is the present worth of cash flows that begin at $30,000 and decrease at 10% per year for 5…

A: Given that , Cash flows = $30,000 no.of years (t)= 5 years interest rate (r)= 15%

Q: enues of $40,000 every 6 months and make $1200 per month payments. What is the Present Worth of…

A: The given problem can be solved using PV function in excel. PV function computes current balance in…

Q: present value

A: Present Value is the computed amount today of either a single sum amount or a series of payments to…

Concept explainers

Conversion Cycle

Conversion cycle is also known as cash cycle or net operating cycle. Conversion cycle refers to how much time a company takes to turn its investments which is done from stock or any other financial resources into cash flows from sales.

Question

If my beginning cash balance is 100,000 with
current A/R 50,000 net terms of 30, sales by
quarter 100,000 and my COGS is 70%. rent =
$2500, payroll: 2,000 per month, payroll
taxes: paid weekly at a rate of 15% of payroll.
how do I build a projected cash flow for the
year, by month?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Assume that an investment of 100,000 produces a net cash flow of 60,000 per year for two years. The discount factor for year 1 is 0.89 and for year 2 is 0.80. The NPV is a. 0 b. 6,800 c. 1,400 d. (4,000)
If my beginning cash balance is 100,000 with current A/R 50,000 net terms of 30, sales by quarter 100,000 and my COGS is 70%. rent = $2500, payroll: 2,000 per month, payroll taxes: paid weekly at a rate of 15% of payroll. how do I build a projected cash flow for the year, by month?
If projected net cash flow for November is ($10,000); beginning cash balance is $4,000; minimum cash balance is $3,000; beginning loan balance is $8,000, what will be the cumulative loan balance and the ending cash balance at the end of November?
Your firm expects to receive a $40,000 payment from a supplier in 40 days. What is the present value of this cash inflow? Assume an annual discount rate of 4%. Use simple interest.
Green Corporation anticipates a cash requirement of P1,000 over a 1- month period. It is expected that cash will be paid uniformly. The annual interest rate is 24 percent. The transaction cost of each borrowing or withdrawal is P30. Requirement: (a) What is the optimal cash balance? (b) What is the average cash balance?
A business plans to use £20,000 of cash during the forthcoming year. It holds most of its cash in a deposit account from which it costs £30 to make each withdrawal and which pays interest at 10 per cent p.a. What is the optimal size for each withdrawal?
Your firm expects to receive a $20,000 payment from a supplier in 25 days. Calculate the increase in the cash inflow's present value if the cash inflow can be collected 5 days sooner. Assume an annual discount rate of 10%. A. -$56.18 b. $27.07 c. $19,9972.64 d. $18,587.25
Leyton Lumber Company has sales of $12 million per year, all oncredit terms calling for payment within 30 days, and its accounts receivable are $1.5 million.What is Leyton’s DSO, what would it be if all customers paid on time, and how much capitalwould be released if Leyton could take action that led to on-time payments?
A Student loan totals $30,000 at graduation. The nominal interest rate is 12% compounded monthly, andthere will be 32 payments beginning 1 month after graduation. What is the monthly payment? What isowed after the first 2 years of payments? Please show work clearly, and cash flow diagram..
Suppose that LilyMac Photography has annual sales of $230,000, cost of goods sold of $165,000, average inventories of $4,500, average accounts receivable of $25,000, and an average accounts payable balance of $7,000.Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Limitless Styles has a 45 day accounts payable period. The firm has expected sales of $900, $1,200, $1,900, and $2,600, respectively, by quarter for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $600 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for Quarter 3 of the next year? Assume that a year has 360 days. A)$1,195 B)$1,085 C)$1,575
What is the APR of return for a $10,000 treasury bill maturing in 2 months if you pay $9,800 for it?